Hi, All,
I’m trying to create a list of checkboxes based on data from a Microsoft Database. Here is what I have so far:
[CODE]
<body>
<form name = “folderSelect”>
<table>
<% adoConn = new ActiveXObject(“ADODB.Connection”);
adoConn.Open(“Provider = Microsoft.Jet.OleDB.4.0; Data Source = C:/Fake2.mdb”);
adoRS = new ActiveXObject(“ADODB.Recordset”);
adoRS.Open(“SELECT ID, Name FROM Folder WHERE Parent = 1”, adoConn);
while (!adoRS.eof) {
%> <tr>
<td><input type = “checkbox” name = “check<%= adoRS(0) %>” onClick = “show(this)”><%= adoRS(1) %></td>
</tr>
adoRS.movenext;
<% }
adoRS.close;
adoConn.close;
%> </table>
</form>
</body>
Unfortunately when I try to view the page, I get an error saying “adoConn” is unrecognized. What am I missing? I’m new to Javascript, so it’s probably something obvious. (At least I hope so!)
Thanks!