I've have this code where I use read as a boolean field it's just a enum field with a value of ('0','1').
Set rs = objConn.execute("UPDATE pm SET read = 0 (Where id = "&strid&") ")
But it won't update I get this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e09'
[TCX][MyODBC]You have an error in your SQL syntax near 'read = 0 (Where id = 1) ' at line 1
I'm rather new to mysql and is mostly used to Access so I might be doing something basic wrong.