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
