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

[David E. Crawford]

Well, your post is not particularly clear. Have you tried running that exact
query inside Microsoft Access?  Assuming that note is a "text" field
(character) and that userid is numeric and skill is numeric, this query
should work just fine. However, if it doesn't work in Access directly it
won't work in ColdFusion via CFQUERY.

DC

----- Original Message -----
From: "Thomas Chiverton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, May 01, 2001 10:49
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