take your quotes off numeric fields, ODBC treats values surounded by single
quotes as text fields.
Also if you didn't take it out for security reasons, you need a valid
datasource name.
Fred
----- Original Message -----
From: "Jay Patton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, February 06, 2001 5:04 PM
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
