> I keep getting this error message, have racked my brains,
> doublechecked field names form names and table names but
> still haven't got a clue as to the problem.
> ...
> ODBC Error Code = 37000 (Syntax error or access violation)
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
> statement.
> SQL = "INSERT INTO tblNews ( OrgID, Date, Subject, Article, Article,
> DateModified)
> VALUES (2769, '8/1/2001', 'Heading', 'Article notes', 31,
> '{ts '2001-01-08 09:49:58'}')"
Looks like double vision. You've got "Article" listed twice in your field
list, and you're trying to insert a string in the first one and an integer
in the second.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
voice: (202) 797-5496
fax: (202) 797-5444
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
