Low cost ecommerce web development India flash website design
Updating Records
If you know how to insert records, then updating them is a breeze. Because
you’re already come more than halfway while inserting records!
<HTML>
<HEAD>
<TITLE>Student Records</TITLE>
</HEAD>
<BODY>
<%
Dim DB
Set DB = Server.CreateObject (“ADODB.Connection”)
DB.Mode = adModeReadWrite
DB.Open ("PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=" +
“C:\Databases\Students.mdb”)
Dim RS
Set RS = Server.CreateObject (“ADODB.Recordset”)
RS.Open “SELECT * FROM Students WHERE FirstName = ‘Manas’”,
DB, adOpenStatic, adLockPessimistic
RS (“Email”) = “mynewemail@manastungare.com”
RS (“DateOfBirth”) = CDate(“4 Feb, 1980”)
RS.Update
%>
</BODY>
</HTML>
Freelance web designer ASP PHP ecommerce web development India