Why even create the temp variable?? <cfset QuerySetCell(...)>
chris >-----Original Message----- >From: S. Isaac Dealey [mailto:[EMAIL PROTECTED] >Sent: Tuesday, June 10, 2003 1:14 PM >To: CF-Talk >Subject: Re: Is there a good way to do this? > >You weren't too far off... > ><cfoutput query="getreg" > > <cfloop index="i" list="#columnlist#"> > <cfset temp= QuerySetCell(getreg,i, > replace(getreg[i][currentrow],"'", > "''","all"),currentrow)> > </cfloop> ></cfoutput> > >Sorry for the wrap... > >> 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/uns >> ubscribe.cfm?user=633.558.4 > > > > >s. isaac dealey 972-490-6624 > >new epoch http://www.turnkey.to > >lead architect, tapestry cms http://products.turnkey.to > >tapestry api is opensource http://www.turnkey.to/tapi > >certified advanced coldfusion 5 developer >http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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