> 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>
For MS SQL, the format for an update statement is, in general, UPDATE tablename SET col1=value1, col2=value2... WHERE keycolumn=value3 Stephen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm

