Or .. if you *must* use FROM for a field name, put it in " "
Todd Ashworth
| > 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
| >
| >
|
| --------------------------------------------------------------------------
----------------------
| 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?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
