If your database is in Microsoft Access, I think that a yes/no field is
actually numeric, so you don't need the single quotes around #valid#. No=0
and Yes=1 or -1.
Lucy
>From: "Jeremy Toevs" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: Update Error
>Date: Thu, 09 Nov 2000 08:37:26 -0800
>
>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">
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
------------------------------------------------------------------------------------------------
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]