you have your ids as text fields when inserting the values. my first
thought would be to remove them.
chris olive, cio
cresco technologies
[EMAIL PROTECTED]
http://www.crescotech.com
-----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
