I've also been caught on more than one occasion passing a userid as a number
when it is, in fact, a string in the database.
Just a thought.
Scott
Scott Brader
Prairie Software Development LLC
101 East Sadd Street
PO Box 235
North Prairie, WI 53153-0235
Phone: 262.392.9173
Fax: 262.392.9174
Toll Free: 888.821.3427
Mobile: 262.490.1376
<http://www.prairiesoftdev.com>
Amateurs practice until they get it right,
Experts practice until they can't get it wrong.
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 9:50
To: CF-Talk
Subject: RE: Update in CFquery is failing, somone code check this ?
> have you tried outputting those variables to make sure
> they're what you
> expect (ie - not null)?
Have you tried reading my post ?
> > [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"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
