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

[Thomas Chiverton]

> 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