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

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:
how do i update my database with the help of update syntax in html <text/javascript>? How to write 'where' statement in this?
How to update record to database? I have trouble with the following code
Advertisements
HQL Update Statement to update database table
how to update checkbox list in database
Syntax error in my UPDATE..please advise
how to update
how to make JTable to add delete and update sql database table
How can I to my database to my application
Update statement
How to update,Delete database values from jtable cells ..
how to update values of a html form into an excel table using java servlets?
How can I protect my database password ?
how to update the value of jslider
how to update the value of jslider
how to update the value of jslider
how to update the value of jslider
how to update the value of jslider
i want to update values
how update JTable after adding a row into database
I want to update the multiple values of database depending on checkbox..? Please help me out..
how do i write a java program for this??
How to update table in Hibernate
How to update,Delete database values from jtable cells ..
How to update,Delete database values from jtable cells ..
how to update image in php
How to insert and update all column values of database from jtable.
How to insert and update all column values of database from jtable.
update database
how to update the text file?
how do i use sql like query in my jsp page
The UPDATE Statement
How to update clob??
How do I write a correct micro-benchmark in Java?
How to insert and update all column values of database from jtable.
update statement in mysql
java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
update statement in mysql
how to update combobx's selected value to database with respect toselected multiple checkboxes
How can I connect my database to my application ?
how to update the text file?
JDBC Update Statement Example
The Update Statement in SQL.
How do I install urllib2 library in my Python module
Update Database from jsp
how do i allow users to download a xls file in html?
The UPDATE Statement, SQL Tutorial
JDBC Video tutorial - How to update Data in a MySQL Database?
using case in update statement
How do I write a program to manage an employee's business and personal contacts?
Where to update the Hibernate tools?

Ads