| | |
| |
PowerASP active server pages asp.net microsoft .net framework sdk learn asp what is asp tutorial learn asp.net CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
UPDATE syntax error but all looks good |
|
From: |
RJB |
|
Date: |
2/26/1999 10:00:58 AM |
|
IP: |
199.224.76.54 |
I'm getting an UPDATE syntax error and I've gone over and over it. Is something else wrong?
code:
on error resume next
form_Password=request.form("Password")
form_Email=request.form("Email")
form_Title=request.form("Title")
form_URL=request.form("URL")
form_BannerURL=request.form("BannerURL")
form_Description=request.form("Description")
form_User=request.form("User")
set conn=server.createobject("adodb.connection")
cnpath="DBQ=" & server.mappath("linker.mdb")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; " & cnpath
SQLstmt = "UPDATE linker SET Password='" & form_Password & "', Email='" & form_Email & "', Title='" & form_Title & "', URL='" & form_URL & "', BannerURL='" & form_BannerURL & "', Description='" & form_Description & "' WHERE User='" & form_User & "'"
Set RS = Conn.Execute(SQLStmt)
If err.number>0 then
response.write "VBScript Errors Occured:" & "<P>"
response.write "Error Number=" & err.number & "<P>"
response.write "Error Descr.=" & err.description & "<P>"
response.write "Help Context=" & err.helpcontext & "<P>"
response.write "Help Path=" & err.helppath & "<P>"
response.write "Native Error=" & err.nativeerror & "<P>"
response.write "Source=" & err.source & "<P>"
response.write "SQLState=" & err.sqlstate & "<P>"
end if
IF conn.errors.count> 0 then
response.write "Database Errors Occured" & "<P>"
response.write SQLstmt & "<P>"
for counter= 0 to conn.errors.count
response.write "Error #" & conn.errors(counter).number & "<P>"
response.write "Error desc. -> " & conn.errors(counter).description & "<P>"
next
else
response.write "<B>Everything Went Fine. Record is updated now!</b>"
response.write "<br>" & SQLstmt
end if
rs.close
set rs=nothing
Conn.Close
set conn=nothing
I am getting this response back:
Database Errors Occured
UPDATE linker SET Password='word', Email='beaujard@epix.net', Title='The Home Page', URL='http://thehomepage.com', BannerURL='http://thehomepage.com/banner.gif', Description='The Home Page' WHERE User='name'
Error #-2147217900
Error desc. -> [Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
PLease HELP :(
|
Follow Up - Re: UPDATE syntax error but all looks good - Harlan 2/26/1999 10:37:33 AM
Follow Up - Re: UPDATE syntax error but all looks good - yeh 3/2/1999 10:28:45 PM
|
|
|
|
|
|
