no need to get testy :)
it's perplexing. i checked the reserved word list for access (i thought NOTE
might be) but nothing is in the reserved word list that you're using.
what about the code immediately before or after the CFQUERY? anything there
that looks suspicious? if you could post more of the code (not just the
query, but what's around it) from that file, maybe that will offer some
clue. or if you want to send me the code off-list i'd be happy to look at
it.
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 01, 2001 7:50 AM
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