RE: Update in CFquery is failing, somone code check this ?

[Jason Lees (National Express)]

I think you might find that the Skill field is now 2 and not 1 Re-read your
e-mail, 

'The previous query (update con_list set
skill_level=2 where userid = 32715281 and skill=1) on the same datasource
finishes fine.'

Technically the critera you want to update doesn't exist any more there for
no record therefore an Error.

QED

Jason Lees
National Express 
Systems Department.
E-Mail : [EMAIL PROTECTED]



-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 11: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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists