March 15th, 2003, 09:33 AM
Join Date: Dec 2002
Time spent in forums: 35 m 5 sec
Reputation Power: 0
Problem with INSERT statement in <cfquery>
I'm having a problem with creating an INSERT statement with the cfquery tag. I'm just testing at the moment and I can use SELECT
ok, but not INSERT. can anyone give me a clue as to what's happening?
the code is...
INSERT INTO visitors (visitor, datetime) VALUES ('daniel', 'now')
...and the error is...
Error Executing Database Query.
[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement...