Hi
i have the following html code that is working.
<html>
<head>
<title>Entitled Document</title>
<script language="JavaScript" >
function condb()
{
var cn = new ActiveXObject("ADODB.Connection");
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = d:\siel.mdb";
var rs = new ActiveXObject("ADODB.Recordset");
var SQL = "select fname, mname, lname from hd where fname = 'Joe'";
cn.Open(strConn);
rs.Open(SQL, cn);
fname.value = rs(0);
lname.value = rs(2);
mname.value = rs(1);
rs.Close();
cn.Close();
}
</script>
</head>
<body>
<br />
First <input type="text" name="fname" />
Middle
<input type="text" name="mname" />
Last <input type="text" name="lname" />
<input type="button" value="submit" onClick="condb()">
</body>
</html>
I want to store the dataset in an array then use it to populate a listbox.
and I need the listbox.value to be lname
can you help ?
thank you
Bookmarks