Database access using Java Script

What is the best way to access/query data using javascript. I have to query an Oracle database.
Any sample code will be appreciated.

Regards,
Neekat

JavaScript can not access a database directly. IE can use ActiveX, but that is as close as you can get.

Eric

What about an XML document. Can I access data from an XML document using JS. The data is not that much so I can use an XML document. If yes, how to access using JS.

Using XMLHttpRequest (aka Ajax) you can access an XML document on the server. You cannot access anything on the client.

The XML document also has to be on the same domain with Ajax.

Eric

I am confused.
If the document is stored on C:\home\code\menu.xml so can I access it using this code or not from a template which is stored on the same drive?

var xmldoc = new ActiveXObject("Microsoft.XMLDOM");
xmldoc.async = false;
xmldoc.load("C:\home\code\menu.xml")

Regards,
Neekat

When you mentioned JavaScript, the assumption was that the document would be served by a web server, in which case you can not access a document on a local machine using the "C:\..." notation. If you open the HTML file directly on your local machine, you can, but then there's not much point in making it a web page.

Here is a basic example:

<html>
  <head>
    <script type="text/javascript">
      var reqXML;     
      function LoadXMLDoc(url){
        if(window.XMLHttpRequest){ 
          reqXML = new XMLHttpRequest(); 
        }
        else if(window.ActiveXObject){ 
          reqXML = new ActiveXObject("Microsoft.XMLHTTP"); 
        }           
        if(reqXML){
          reqXML.open("POST", url, true);
          reqXML.onreadystatechange =  function(){
                                 if(reqXML.readyState==4){
         if(reqXML.status == 200)BuildXMLResults();
   else alert("There was a problem retrieving the XML data:\n" + reqXML.statusText);
 }
   }
          reqXML.send(null);
        }
      }
 
  function BuildXMLResults(){
        var xmlDoc = reqXML.responseXML.documentElement;
        var nodes = xmlDoc.childNodes;
        document.getElementById("divOut").innerHTML = nodes[0].firstChild.text;
      }
 
      window.onload = function(){
        LoadXMLDoc("http://radio.javaranch.com/pascarello/rss.xml");
      }
    </script>
  </head>
  <body>
    <div id="divOut"></div>
  </body>
</html>

Eric