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

[Howie Hamlin]

Maybe that's why he's now out of a job <g>

Seriously, though - have you tried putting square brackets around the word
"note?"

Regards,

Howie Hamlin - inFusion Project Manager
On-Line Data Solutions, Inc.
www.CoolFusion.com
631-737-4668 x101
inFusion Mail Server (iMS) - The Intelligent Mail Server

----- Original Message -----
From: "Thomas Chiverton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 11:16 AM
Subject: RE: Update in CFquery is failing, somone code check this ?


> > Create a query and use the SQL view
> The paperclip rather helpfuly says 'Syntax error in update statement' when
I
> try and save
> "update con_list set note = 'dr' where userid = 32715281 and skill =1;"
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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