> 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
- Re: Update in CFquery is failing, somone co... Bud
- RE: Update in CFquery is failing, somone co... Dylan Bromby
- Re: Update in CFquery is failing, somone co... Tim Painter
- RE: Update in CFquery is failing, somone co... Thomas Chiverton
- RE: Update in CFquery is failing, somo... Erika L Walker
- RE: Update in CFquery is failing, somone co... Andy Ewings
- RE: Update in CFquery is failing, somone co... Thomas Chiverton
- RE: Update in CFquery is failing, somone co... Thomas Chiverton
- RE: Update in CFquery is failing, somo... Dylan Bromby
- RE: Update in CFquery is failing, somone co... Andy Ewings
- Re: Update in CFquery is failing, somone co... Thomas Chiverton
- Re: Update in CFquery is failing, somo... David E. Crawford
- RE: Update in CFquery is failing, somo... Dylan Bromby
- RE: Update in CFquery is failing, somo... Scott Brader
- RE: Update in CFquery is failing, somone co... Andy Ewings
- RE: Update in CFquery is failing, somo... Dylan Bromby
- RE: Update in CFquery is failing, somone co... Jason Lees (National Express)
- RE: Update in CFquery is failing, somo... Dylan Bromby
- RE: Update in CFquery is failing, somone co... Howarth, Craig (IBK-NY)
- RE: Update in CFquery is failing, somo... Dylan Bromby
- RE: Update in CFquery is failing, ... Dylan Bromby