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

[Jason Lees (National Express)]

Cant see anything wrong with the syntax, have you tried removing the spaces
before and after all the ='s in the query string,shouldn't make a difference
but worth trying.

is the DSN correct?

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



-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 4:22 PM
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, 
>
> Technically the critera you want to update doesn't exist any 
> more there for
> no record therefore an Error.

Shame that the error is 'syntax error', and not 'no records updated', which
iirc wont be reported 'cuase its OK for an update to not update anything.

Anyway, its still a bug, now fixed, so thanks for spotting it :-) 
Dont suppose you've secretly found out where the syntax error is ?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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