Is note a reserved word in Access? Try [note] = 'dr'.
Craig
> -----Original Message-----
> From: Jason Lees (National Express) [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, May 01, 2001 11: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
