update tblProfiles set strSelect = <cfqueryparam value="#No_Access_List#" cfsqltype="CF_SQL_LONGVARCHAR">, strShowMe = <cfqueryparam value="#form.dir_access#" cfsqltype="CF_SQL_LONGVARCHAR"> where strUsername = '#auth#'
:) hth tw tony weeg uncertified advanced cold fusion developer tony at navtrak 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>? <cfquery name="qUpdateProfile" datasource="prefs"> UPDATE tblProfiles ( strSelect, strShowMe ) VALUES ( <cfqueryparam value="#No_Access_List#" cfsqltype="CF_SQL_LONGVARCHAR">, <cfqueryparam value="#form.dir_access#" cfsqltype="CF_SQL_LONGVARCHAR"> ) WHERE strUsername = '#auth#' </cfquery> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Get the mailserver that powers this list at http://www.coolfusion.com

