SQL in Javascript

[dude81]

hello,

Can SQL commands be executed on a database like oracle and return the value to Javascript..
I s there any possibilty of using Javascript like that??

[Vic]

Best way to access your database is using server-side language. You can then pass the results to your javascript code either via html object, or through writing the variable assignment directly to the page (response.write in ASP).

[Khalid Ali]

Straight answer to your question is "No", you can not do that using JavaScript...this process has to take care of on the server side.

[felgall]

If you need the info in Javascript to process it then you will need to set up your Javascript to be parsed on the server to do server side substitutions via your chosen server side language before the script is downloaded to the browser. You can force this for external javascripts by changing the file extension eg:

<script type="text/javascript" src="myscript.php"></script>

myscript.php would be a combination of Javascript and PHP where the PHP substitutes into the Javascript prior to downloading.