doesn't it need a name for the query?
it would be helpful to know field typing.
is this a form update?
> -----Original Message-----
> From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, November 09, 2000 10:37 AM
> To: CF-Talk
> Subject: Update Error
>
>
> 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˙sts
> 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]
