maybe the "from" field, that is a reserved SQL word ?
Greets,
Gast�n
> -----Mensaje original-----
> De: Jeremy Toevs [SMTP:[EMAIL PROTECTED]]
> Enviado el: Jueves 9 de Noviembre de 2000 13:37
> Para: CF-Talk
> Asunto: 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/[email protected]/
> 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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
