how do i update my database with the help of update syntax in html ? How to write 'where' statement in this?
var sqlmek="update into Student_info set(ID,s_name,l_name,address,pincode,mobile_no,mail_id)values (";
sqlmek = sqlmek + id.value + ",'" + fname.value + "','" + lname.value + "','";
sqlmek = sqlmek + address.value + "'," + pin.value + "," + mob.value + ",'" + mail.value + "')";
alert(sqlmek);
var cn = new ActiveXObject("ADODB.Connection");
alert('Hi!');
var strConn = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source = C:/Aptech/dhruv/SMS.mdb";
alert('Hello!');
var rs = new ActiveXObject("ADODB.Recordset");
alert('How are you!!');
cn.Open(strConn);
alert('I am Fine!');
rs.Open(sqlmek, cn);
alert('Fine');
alert('Press OK to Update your Records Successfully!!.........');
}
View Answers
Related Tutorials/Questions & Answers:
Advertisements