have you tried outputting those variables to make sure they're what you
expect (ie - not null)?
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 3:43 AM
To: CF-Talk
Subject: Update in CFquery is failing, somone code check this ?
I have:
<cfquery name="update2" datasource="ps_skills">
update con_list set note = 'dr' where userid = #session.userid# and skill =
#form.skill#
</cfquery>
And it is dieing with:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.
SQL = "update con_list set note = 'dr' where userid = 32715281 and skill =
1"
Data Source = "PS_SKILLS"
and I cant sport the error. The previous query (update con_list set
skill_level=2 where userid = 32715281 and skill=1) on the same datasource
finishes fine.
Regards,
Thomas Chiverton
Intranet Architect and Desktop Analyst
01565 757 909
It's not a job, it's an adventure
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
