think 'time' or 'money' might be reserved words in access. if you look in
the design view of the table those column names might be in [braces]. rename
your columns.
Alexander Sicular
Technical Director, Information Technology
The Neurological Institute of New York
Columbia University
212.305.1318
[EMAIL PROTECTED]
-----Original Message-----
From: Jay Patton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 06, 2001 5:05 PM
To: CF-Talk
Subject: Syntax error....
Can anyone tell me what is wrong with this insert statement?
Ive been looking at this for about an hour now and cant figure it out....
I get the following error:
Error Diagnostic Information
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement.
SQL = "INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place,
Time, Points, AdjPoints, Money) VALUES ( '1', '2', '7', '1', '0', '50',
'125', '5000')"
Data Source = "??????"
<!--<cfquery name="PutResults" datasource="?????"dbtype="ODBC">
INSERT INTO ResultsManager (RodeoID, EventID, ContestantID, Place, Time,
Points, AdjPoints, Money)
VALUES (
'#RodeoID#',
'#EventID#',
'#ContestantID#',
'#Place#',
'#Time#',
'#Points#',
'#AdjPoints#',
'#Money#')
</cfquery>
-->
Thanks,
Jay Patton
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
