I think valid = '#valid#' needs to be changed, if it's a yes/no field
#Valid# should either be 0 or 1 without quotes or basically:
Valid=0
Valid=1
That should do it...
Gregory Harris
Web Developer
Stirling Bridge Group LLC
----- Original Message -----
From: "Jeremy Toevs" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 8:37 AM
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
>
>
------------------------------------------------------------------------------------------------
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]
