that may be, but i don't think that would throw a SYNTAX error. it just
wouldn't update the field.
-----Original Message-----
From: Jason Lees (National Express)
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 8:01 AM
To: CF-Talk
Subject: RE: Update in CFquery is failing, somone code check this ?
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