Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa HTML how do i update my database with the help of update syntax in html ? How to write 'where' statement in this?

Have Programming Question? Ask it here!
 
 
 


Dhruv Patel
how do i update my database with the help of update syntax in html ? How to write 'where' statement in this?
0 Answer(s)      2 years and a month ago
Posted in : HTML


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!!.........');
}

Advertisement
View Answers

Related Tutorials/Questions & Answers:
Advertisements
Advertisements
 

 

 

DMCA.com