SQL Server Compact. There was an error parsing the query.

Question

I cannot figure out why this is not working. I get the same thing when I try to do an update query as well.

Here is the error " There was an error parsing the query. [ Token line number = 1,Token line offset = 43,Token in error = where ] "

Here is the actual Query INSERT INTO ads (title,price,body,enabled,where,interval,posted) VALUES('test','899','test',True,'Columbus',15,'11/25/2009 10:12:30 AM')

Where would be 'Columbus'

I am using visual studio express 2008 C#

Answer 1

WHERE is a reserved word, try wrapping it in brackets

INSERT INTO ads (title,price,body,enabled,[where],interval,posted) 
VALUES('test','899','test',True,'Columbus',15,'11/25/2009 10:12:30 AM')