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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
