Hi Buddzy
Can you plz help to connect to Access DataBase input from HTML form using insert statement. I am still new on programming with html here is my code .
[HTML]<html>
<head>
<title>Entitl ed Document</title>
<script language="JavaS cript" >
function getSubmit()
{
var name1 = eval(document.f orm1.names.valu e)
var cn = new ActiveXObject(" ADODB.Connectio n");
var strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source = G:\clientDB.mdb ";
cn.Open(strConn );
var rs = new ActiveXObject(" ADODB.Recordset ");
// I need help for the following line ("' + name1 +' " )
var SQL = "insert into Customers values( "' + name1 +' " )";
rs.Open(SQL, cn);
//alert(rs(0));
rs.Close();
cn.Close();
}
</script>
</head>
<body>
<FORM name="form1" action="mailto: email@domaine.c om" method="post">
<input type="text" name="names" />
<input type="button" value="submit" onclick="getSub mit()"/>
</form>
</body>
</html>[/HTML]
regards,
Mkhize
Can you plz help to connect to Access DataBase input from HTML form using insert statement. I am still new on programming with html here is my code .
[HTML]<html>
<head>
<title>Entitl ed Document</title>
<script language="JavaS cript" >
function getSubmit()
{
var name1 = eval(document.f orm1.names.valu e)
var cn = new ActiveXObject(" ADODB.Connectio n");
var strConn = "Provider=Micro soft.Jet.OLEDB. 4.0;Data Source = G:\clientDB.mdb ";
cn.Open(strConn );
var rs = new ActiveXObject(" ADODB.Recordset ");
// I need help for the following line ("' + name1 +' " )
var SQL = "insert into Customers values( "' + name1 +' " )";
rs.Open(SQL, cn);
//alert(rs(0));
rs.Close();
cn.Close();
}
</script>
</head>
<body>
<FORM name="form1" action="mailto: email@domaine.c om" method="post">
<input type="text" name="names" />
<input type="button" value="submit" onclick="getSub mit()"/>
</form>
</body>
</html>[/HTML]
regards,
Mkhize
Comment