Syntax error in UPDATE line

[chaos986]

I'm trying to update an ACCESS form when a form is submitted. I've looked over it for a few days and can't find a solution that satifies the surver.

The problem line is: objConn.Execute("UPDATE Questions SET question = '" & question & "' WHERE ContentPage = '" & ContentPage & "' QNumb = '" & QNumb & "' ;&quot

The error i get is:


Microsoft OLE DB Provider for ODBC Drivers error '80040e14'

[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'ContentPage = 'airbladder' QNumb = '3''.




Mike2
chaos986@yahoo.com
http//

http://www.geocities.com/chaos986/

also see my small busness work @ http:/

http://www.michaelswgp.com

 

[swilliams]

Try this:

objConn.Execute("UPDATE Questions SET question = '" & question & "' WHERE ContentPage = '" & ContentPage & "' AND QNumb = '" & QNumb & "' ;&quot

You might also find that you still get an error if your QNumb field is a number type. This is because you have quotes around the value of this field, but number types do not need this. If this is the case, try this:

objConn.Execute("UPDATE Questions SET question = '" & question & "' WHERE ContentPage = '" & ContentPage & "' AND QNumb = " & QNumb & ";&quot

Simon