I am not sure if it is the way the mail wrapped the text, but is there a
carriage return after skill = ?
If so, then the query may be trying to pass a carriage return with the
#form.skill#
(I just ran into this a couple of days ago)
Tim P.
----- Original Message -----
From: "Thomas Chiverton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 6:43 AM
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
