it's already a list. delimited with a pipe character.
you can use any list function on it...you just need to specify the
delimter in the list function.
<cfset myList = "this|that|the other" />
<cfset myArray = listToArray(myList, '|') />
You can also loop through it.
<cfloop list="#myList#" index="client" delimiters="|">
#client#<br />
</cfloop>
On 7/10/06, Nathan C. Smith <[EMAIL PROTECTED]> wrote:
> I have a query (well, database) with a field in it that is a hack. It
> basically contains a list.
>
> This|that|other
>
> In CF 4.5 I could treat this as a list an loop through it. It is drawing an
> error in CF 7.02: "Complex object types cannot be converted to simple
> values."
>
> In the case below I assigned the query field to a variable -
> practicearealisting hoping that might help.
>
> <cfloop list="#listsort(PracticeAreaListing,'text', "asc","|")#"
> index="Client" delimiters="|">
> <li>#client#</li>
> </cfloop>
>
> In short, what I am asking, is for a way to convert this list-in-a-string to
> a real list. And if there is a regular way of doing this? I've a feeling
> the answer is staring me in the face. Maybe somebody could poke my eye with
> it? Thanks.
>
> -Nate
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/cf_lists/message.cfm/forumid:4/messageid:246031
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
