How's bout giving us the post-parse SQL in the debug output?
J
On Thu, 09 Nov 2000 08:37:26 -0800, in cf-talk you wrote:
>I recieved the following error and can not figure out how to fix it. My query looks
>just like the rest of my other ones, but this one just doesn't seem to work. Can you
>help me out?
>
>===================================
>Error Occurred While Processing Request
>Error Diagnostic Information
>ODBC Error Code = 37000 (Syntax error or access violation)
>[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
>The error occurred while processing an element with a general identifier of
>(CFQUERY), occupying document position (2:1) to (2:28).
>===================================
>
>Here is my query. All fields are in text format. No date formats. Valid is a yes/no
>field. I just can't figure out what is wrong.
>
><cfif isdefined("valid")><cfset valid=1><cfelse><cfset valid=0></cfif>
><cfquery datasource="idata">
>UPDATE Snowboard_Riders
> SET loginname='#loginname#',
> password='#password#',
> years='#years#',
> email='#email#',
> from='#from#',
> fav_place='#fav_place#',
> trick='#trick#',
> started='#started#',
> ride_exper='#ride_exper#',
> valid='#valid#'
>WHERE Rider_ID = #Rider_ID#
></cfquery>
>
><cflocation url="updatedone.cfm?LoginName=#LoginName#" addtoken="yes">
>
>------------------------------------------------------------------------------------------------
>Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
>Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
>with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]