-
Expert
86 Answers
- Posted on Dec 31, 2009
Re: Can i access database using javascript ?
You could use something similar to below:
----Begin Script---
- <html>
- <head>
-
- <script language="JavaScript">
-
- var cn = new ActiveXObject("SQLiteDb.Connection");
- if (typeof(cn)=="undefined" || cn==null)
- alert("Unable to create the connection object!");
- else
- alert("Connection object was successfully created!");
-
- var strConn = "Database=db/test.db";
- function getdata(){
- cn.Open(strConn);
- var rs = new ActiveXObject("SQLiteDb.Recordset");
- var SQL = "SELECT CoName from Companies WHERE CoID=1";
- rs.Open(SQL, cn);
- alert(rs(0));
- rs.Close();
- cn.Close();
- }
- </script>
-
- </head>
- <body>
-
- <input type="button" value="Get data"
- onclick="getdata()">
- </body>
- </html>
---End Script---
×