Quote:
Originally Posted by robbied72
As alex said learn some ASP as you will need to know how to query the database, once you have done that then get a connection string from here. |
<
html>
<head>
<title>Entitled Document</title>
<script language="JavaScript" >
function getSubmit()
{
var LastName;
var Firstn = names.value ;
var cn = new ActiveXObject("ADODB.Connection");
//here you must use forward slash to point strait
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = C:/clientDB.mdb";
var rs = new ActiveXObject("ADODB.Recordset");
//var
SQL = "INSERT INTO Customers(FirstName, Surname)"
//+ " VALUES ( '"+ names.value +"', '" + surname.value +"')";
var
SQL = "select Surname, DOB from Customers where FirstName = '" + Firstn + "'";
cn.Open(strConn);
rs.Open(
SQL, cn);
surname.value = rs(0);
DOB.value = rs(1);
//alert(rs(0));
rs.Close();
cn.Close();
}
</script>
</head>
<body>
<input type="text" name="names" />
<input type="text" name="surname" />
<input type="text" name="DOB" />
<input type="button" value="submit" onclick="getSubmit()">
</body>
</
html>