SQL Syntax Question

[theflyingminst]

Hi I keep getting this error:

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

[Microsoft][ODBC Microsoft Access Driver] Syntax error in string in query expression '" WHERE id=229'.

My SQL statement is as follows:

SQL = "UPDATE Table SET Field1 = "", Field2 = "", Field3 = "" WHERE id="&id

ID is an autonumber field and I was under the impression until now that was syntax.


Thanks!

[Phill Pafford]

What language are you using in your application? PHP, ASP?

In the blank "" in the code do you supply data?

SQL = "UPDATE Table SET Field1 = "", Field2 = "", Field3 = "" WHERE id="&id

[MrNobody]

Perhaps you mean this? ...to set those three fields to zero-length string values?

SQL = "UPDATE Table SET Field1 = '', Field2 = '', Field3 = '' WHERE id = " & id & ";"

Use double quotes to enclose the query string and single quotes to enclose string values within the query.