:) this did it :)
<cfloop from = 1 to = #session.menuMatrix.recordCount# index = i>
<cfset fixTheCommas =
querySetCell(session.menuMatrix,"menuitem",replace(session.menuMatrix.menuItem[i],',','','all'),i)>
</cfloop>
i always do this... get lost, send list mail, think about, fix :)
later
tw
On 8/21/05, Jim Davis <[EMAIL PROTECTED]> wrote:
> > -----Original Message-----
> > From: Tony [mailto:[EMAIL PROTECTED]
> > Sent: Sunday, August 21, 2005 7:08 PM
> > To: CF-Community
> > Subject: can you replace a valueList() ...
> >
> > can you do this?
> >
> > listToArray(valueList(replace(session.menuMatrix.menuItem,',',' ','all')))
>
> Breaking this down you can't do:
>
> replace(session.menuMatrix.menuItem,',',' ','all')
>
> Unless session.menuMatrix.menuItem is a string - if it's (as I think it is?)
> a column in a query this won't work.
>
> However what do want at the end? If it's just an array you can already
> access an Query Column as an array.
>
> You can do:
>
> <cfloop from="1" to="#ArrayLen(session.menuMatrix.menuItem)#" index="Cnt">
> <cfoutput>#session.menuMatrix.menuItem[Cnt]#</cfoutput>
> </cfloop>
>
> There's very little Array processing that you can't do with query column as
> it is.
>
> If that's not what you want to do and you really need the delimited list
> first remember that valueList() (and ALL the CF list functions) can accept a
> delimiter as an argument. You don't HAVE to use a comma as your delimiter -
> and I wouldn't if your content has commas. You can pick an odd control
> character or anything that's not going to be in your content.
>
> Jim Davis
>
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49
Message: http://www.houseoffusion.com/lists.cfm/link=i:5:170584
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
