A few things: 1) There is actually no special "List" type in CF - it's just a string that happens to have a delimiter of your choice in it.
2) Is PracticeAreaListing being assigned within a CFOUTPUT query loop? Regardless, you can access a particular column in a particular row of the query like this: TheQueryName["TheColumnName"][1] TheQueryName["TheColumnName"][2] etc. On 7/11/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:246030 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
