The Database Forum

**Niko2005** · 08:18 PM

I need to be able to find a record by a unique code from a ms access database,
take the value of the price field in that record,
then store the value in a javascript variable.

These varibles are being used for calculations.

So can I change the hard coded javascript code
e.g.
var price1=(229); // 229 being $229 the price for item1

to
var price1=(item1); // item1 = 229 - value read from database and stored in variable price1.

Thanks.

--------------------------

This is my test code:

<html>
<head>
<title>test</title>



<script language="javascript">



var c1D41=( <%= HG1DK121I %> );

var xxx=(666)
</script>

<%
'Reset server objects
HG1DK121I.Close
Set HG1DK121I = Nothing
Set adoConHG1DK121I = Nothing
%>
</head>

<body>

<script language="javascript">

document.write('vaiable xxx = ' + xxx);

document.write(c1D41);
</script>

</body>
</html>

----------------

This is the include file HG1DK121I.asp

<%
'Dimension variables
Dim adoConHG1DK121I 'Holds the Database Connection Object
Dim HG1DK121I 'Holds the recordset for the records in the database
Dim strSQLHG1DK121I 'Holds the SQL query to query the database

'Create an ADO connection object
Set adoConHG1DK121I = Server.CreateObject("ADODB.Connection")

'Set an active connection to the Connection object using a DSN-less connection
adoConHG1DK121I.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("db/Price.mdb")

'Create an ADO recordset object
Set HG1DK121I = Server.CreateObject("ADODB.Recordset")

'Initialise the strSQL variable with an SQL statement to query the database
strSQLHG1DK121I = "SELECT Product.Code, Product.System, Product.Group, Product.Product, Product.Price FROM Product WHERE Code='HG1DK121I'"

'Open the recordset with the SQL query
HG1DK121I.Open strSQLHG1DK121I, adoConHG1DK121I

%>

--------------

**chrishirst** · 05-16-2005, 02:57 AM

Write it on to the page with ASP

HTML Code:

<script type="text/javascript">
var price1=(<%=objRS.fields("price")%>)
</script>

**faulkj** · 04-21-2009, 04:18 PM

You are able to connect to Microsoft Access using JavaScript when the HTML file is run locally and the Access .mdb file is accessible to the file system it does not work remotely due to the obvious security issues.

I had a situation where this functionality was actually useful, so I wrote a JavaScript library to simplify the process. This library allows you to execute SQL queries in a single command with the option of selecting the output format of the result-set from choices including JSON, XML, and HTML.

I had a great deal of difficulty finding information or examples of how to connect to Access, so I decided to share my code with the world...

The library is called ACCESSdb and you can get it here!