I need to replace all single quotes with double single quotes in all of the
fields of a query. I know that I could do it in a query but in this case I
am opting not to.
I have come up with this idea of but I am having a problem with the "i[x]"
part. Any ideas?
<cfoutput query="getreg" >
<cfset x=0 >
<cfloop index="i" list="#columnlist#">
<cfset temp= QuerySetCell(getreg, i, replace(i[x],"'", "''","all"), x
) >
<cfset x=x+1 >
</cfloop>
</cfoutput>
Mark W. Breneman
-Macromedia Certified ColdFusion Developer
-Network / Web Server Administrator
Vivid Media
[EMAIL PROTECTED]
www.vividmedia.com
608.270.9770
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
