Can someone help me with an SQL error?
I get the following error:
Microsoft VBScript compilation error '800a0400'
Expected statement
When using this code:
set UpdateConn = Server.CreateObject("ADODB.Connection")
MdbFilePath = Server.MapPath("NWIS.mdb")
UpdateConn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" &
MdbFilePath & ";"
sqlstr = "update NWISUpdate set RequestStatus = 'Complete', Comments = '" &
request.form("Comments") & "' where ID='" & request.form("id") & "'"
UpdateConn.Execute(sqlstr)
UpdateConn.Close
set UpdateConn = nothing
any help is appreciated. Thanks!
---
You are currently subscribed to activeserverpages as: [email protected]
To unsubscribe send a blank email to [EMAIL PROTECTED]
