Hi,
if RodeoID, etc. are integer fields you need to remove the single quotes
around the corresponding values.
HTH,
Chris
> -----Ursprüngliche Nachricht-----
> Von: Jay Patton [mailto:[EMAIL PROTECTED]]
> Gesendet: Dienstag, 6. Februar 2001 23:05
> An: CF-Talk
> Betreff: 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
