Actually, either way would work. Both of the following produce the same
result:
QueryName.ColumnName[RowNumber]
QueryName["ColumnName"][RowNumber]
I had forgotten about this second format which is a good way of getting
around having to use Evaluate().
--
Mosh Teitelbaum
evoch, LLC
Tel: (301) 942-5378
Fax: (301) 933-3651
Email: [EMAIL PROTECTED]
WWW: http://www.evoch.com/
> -----Original Message-----
> From: Philip Arnold [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 10, 2003 4:01 PM
> To: CF-Talk
> Subject: RE: Is there a good way to do this?
>
>
> One word - CFSCRIPT
>
> Also, when you refer to a cell in a query with square brackets it's
> Query[Field][Row]
>
> So it'd be GetReg[i][x]
>
> > From: Mark W. Breneman [mailto:[EMAIL PROTECTED]
> >
> > 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>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
