Isn't FROM a reserved SQL word?
from='#from#',
Todd Ashworth
----- Original Message -----
From: "Simon Horwith" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 09, 2000 12:45 PM
Subject: RE: Update Error
| try replacing : <cfif isdefined("valid")><cfset valid=1><cfelse><cfset
| valid=0></cfif>
| with: <cfif isdefined("valid")><cfset valid="Yes"><cfelse><cfset
| valid="No"></cfif>
| or remove the single quotes in: valid='#valid#'
|
| I'd start there.
|
| ~Simon
|
| > Simon Horwith
| > Certified ColdFusion Developer
| > Fig Leaf Software
| > 1400 16th St NW, # 220
| > Washington DC 20036
| > 202.797.6570 (direct line)
| > www.figleaf.com
| >
|
|
| -----Original Message-----
| From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
| Sent: Thursday, November 09, 2000 11: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=lists 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?sidebar=lists 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?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
