what is the datatype in the db for this field you are trying to update? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337
-----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 7:55 AM To: CF-Talk Subject: re: <cfquery syntax Hi, What's wrong with the below syntax? I think the single quotes around the "commalist" is throwing it for a loop? How can I get around this? If I use double quotes I'll run into the same problem around the "ListGetAt..." code. <cfquery name="Insert" datasource="prefs"> UPDATE tblProfiles SET strSelect='<cfqueryparam value="#ListGetAt(commalist,1,'|')#" 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 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
