Before I even had the valid field in my query I was receiving that error. And I also
tried the valid without the ' '. So I am still stumped.
>>> James Maltby <[EMAIL PROTECTED]> 11/09/00 09:38AM >>>
Your error is with #valid# - you've got it setting above (as numeric) while
below you have it inserting as text '#valid#' = remove the '' marks and it
should work.
James
"You're a big man, but you're out of shape. I do this for a living, so
behave"
"Get Carter" 1964
-----Original Message-----
From: Jeremy Toevs [mailto:[EMAIL PROTECTED]]
Sent: 09 November 2000 16:37
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?sidebarRsts or send a message with
'unsubscribe' in the body to [EMAIL PROTECTED]
