re: MS SQL UPDATE syntax help

2003-08-14 Thread Bushy
Hi, Could someone tell me where I'm going wrong with the below cfquery? cfquery name=qUpdateProfile datasource=prefs UPDATE tblProfiles ( strSelect, strShowMe ) VALUES ( cfqueryparam value=#No_Access_List#

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 cfquery? cfquery name=qUpdateProfile datasource=prefs UPDATE tblProfiles ( strSelect, strShowMe ) VALUES ( cfqueryparam value=#No_Access_List# cfsqltype=CF_SQL_LONGVARCHAR, cfqueryparam

RE: MS SQL UPDATE syntax help

2003-08-14 Thread Tony Weeg
dot net www.navtrak.net office 410.548.2337 fax 410.860.2337 -Original Message- From: Bushy [mailto:[EMAIL 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 cfquery

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:51 AM Subject: re: MS SQL UPDATE syntax help