LANGUAGE="JScript" <%@ %>
<% dbConnection = Server.CreateObject("ADODB.Connection");
cstring = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" + Server.MapPath('registration.mdb');
dbConnection.Open(cstring);
sep = "', '" ;
str = "UPDATE students SET first='" + Request.QueryString("first") + "', last='"
str += Request.QueryString("last") + "', state='" + Request.QueryString("state")
str += "' WHERE sid=" Request.QueryString("sid");
dbConnection.Execute(str);
dbConnection.Close(); + %>
<!-- The SQL statement requires single quotes around text values; one would not use single
quotes if one were modifying a numeric field -->
<!-- Author: Bill Pegram
Filename: modifyaction.asp
La...