- 1). Right-click the file with your Javascript code and select "Open With." Double-click "Notepad" to open the file in Notepad. Double-click another editor if you have a third-party editor that you prefer to use.
- 2). Scroll down the page to the Javascript section. Javascript is denoted in a Web file with the "<script>" tag. For the first line of code, specify the location of the database and set up the connection string. This code shows you how to set up these variables:
var database_path = "C:\\customers.mdb";
var connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + database_path; - 3). Query the database and create a record-set from the results. In this example, a list of customers is created and the customers are stored in a variable called "recordset." A record-set is a list of records returned from the database, and this variable is used to display the results. Type the following code to retrieve data:
var conn = getAdoDb("ADODB.Connection");
conn.open(connection, "", "");
var recordset = getAdoDb("ADODB.Recordset");
query = "select * from customers";
recordset.open(query, conn, adOpenDynamic, adLockOptimistic); - 4). Display the records. This code displays the first record of the record-set:
document.write(recordset.fields(0).value); - 5). Press "Ctrl+S" to save the changes. To verify your results, double-click the file on your computer to open it in a Web browser.
- Advertisement -
- Advertisement -