Try this..
<cfset variables.strSelect = ListGetAt(commalist,1,'|')> <cfquery name="Insert" datasource="prefs"> UPDATE tblProfiles SET strSelect = <cfqueryparam cfsqltype="CF_SQL_LONGVARCHAR" value="#variables.strSelect#"> WHERE strUsername = <cfqueryparam cfsqltype="CF_SQL_VARCHAR" value="#auth#"> </cfquery> -----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 12:55 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
