RE: MS SQL UPDATE syntax help

2003-08-14 Thread Tony Weeg
PROTECTED] Sent: Thursday, August 14, 2003 12:52 PM To: CF-Talk Subject: re: MS SQL UPDATE syntax help Hi, Could someone tell me where I'm going wrong with the below ? UPDATE tblProfiles ( strSelect, strShowMe )

re: MS SQL UPDATE syntax help

2003-08-14 Thread Stephen Hait
> Hi, > > Could someone tell me where I'm going wrong with the below > ? > > > UPDATE tblProfiles > ( > strSelect, > strShowMe > ) > VALUES > ( >cfsqltype="CF_SQL_LONGVARCHAR">, value="#form.dir_access#" cfsqltype="CF_SQL_LONGVARCHAR"> ) WHERE > strUsername = '#auth#' > For MS SQ

Re: MS SQL UPDATE syntax help

2003-08-14 Thread Ewok
heh looks like an INSERT query to me ;) try UPDATE tblProfiles Set blah = blah, blah2 = blah2 where blah = blah cheers - Original Message - From: "Bushy" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, August 14, 2003 9:

re: MS SQL UPDATE syntax help

2003-08-14 Thread Bushy
Hi, Could someone tell me where I'm going wrong with the below ? UPDATE tblProfiles ( strSelect, strShowMe ) VALUES ( , ) WHERE strUsername = '#auth#' ~~~