my guess - now that we all know the answer - is i'm wrong :).
darn list speed :).
-----Original Message-----
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 9:04 AM
To: CF-Talk
Subject: RE: Update in CFquery is failing, somone code check this ?
you have skill and skill_level.
my guess is *you* mixed them up.
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 8:22 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,
>
> 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