|
I have the folowing code
Dim rateCount
rateCount = objRS("rating")
rateCount = rateCount + 1
Dim strUp
strUp = "UPDATE application SET rating =" & rateCount & "Where ID =" & modid
objConn.execute(strUp)
1 must be added to rateCount and updated to the database. When I run the code I get the following error
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '1Where ID =11'.
/VipModels/vote.asp, line 40
Please help
|
