-
Problem with Update' in ASP and Access 97
To whom it may concern,
I am trying to create page that updates a distinctive row in a table in Access database.
I am getting the following error message when I attempt to run my script:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access 97 Driver] Syntax error (missing operator) in query expression '1141 Snyder Rd. G-16'.
/woodlynde/update/update.asp, line 24
The '1141 Snyder Rd. G-16' is data from the Access database.
Here is the script below, can anyone help me? Matthew Gallagher
<html>
<head>
<title></title>
</head>
<body>
<%
set conntemp=server.createobject("adodb.connection "
conntemp.open "arc.Woodlynde","",""
qs="Update Table1 "
qs=qs & "set Class = '" & request.querystring("Class" & "', "
qs=qs & "FirstName =" & request.querystring("FirstName" & ", "
qs=qs & "LastName =" & request.querystring("LastName" & ", "
qs=qs & "MaidenName =" & request.querystring("MaidenName" & ", "
qs=qs & "Address =" & request.querystring("Address" & ", "
qs=qs & "Town =" & request.querystring("Town" & ", "
qs=qs & "State =" & request.querystring("State" & ", "
qs=qs & "PostCode =" & request.querystring("PostCode" & ", "
qs=qs & "HomePhone =" & request.querystring("HomePhone" & ", "
qs=qs & "WorkPhone =" & request.querystring("WorkPhone" & ", "
qs=qs & "Email =" & request.querystring("Email" & "' "
qs=qs & "where id = " & request.querystring("ID" & ";"
set rstemp=conntemp.execute(qs)
conntemp.close
%>
<h3>Record Updated</h3>
<p><a href="../Default.htm">Return to Main Page</a> </p>
</body>
</html>
Thanks a lot!!!!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|