No quotes around <cfqueryparam> <cfquery name="Insert" datasource="prefs"> UPDATE tblProfiles SET strSelect=<cfqueryparam value="#ListGetAt(commalist,1,'|')#" cfsqltype="CF_SQL_LONGVARCHAR"> WHERE strUsername=<cfqueryparam value="#auth#" cfsqltype="CF_SQL_VARCHAR"> </cfquery>
-----Original Message----- From: Bushy [mailto:[EMAIL PROTECTED] Sent: donderdag 4 september 2003 13: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
