once you turn it into a list you can use list functions to access the items.. http://livedocs.adobe.com/coldfusion/8/htmldocs/help.html?content=functions-pt0_13.html
listgetat(foo, 1) and listlen(foo) to return the length of the list unless I'm not understanding what you're asking On Thu, Mar 17, 2011 at 12:23 PM, zac wingfield <[email protected]> wrote: > > Hi all, > > i have a very basic query with pulls DB column header names. which looks like > this: > > SELECT * > FROM ProdFields > WHERE 1 = 2 > > I can then out put the results in a list like this: > > <cfset ColList = listChangeDelims(queryname.columnList, ",</br>")> > <cfoutput>#ColList#</cfoutput> > > but what i need is for each column header name to be available to me to > output seperately. so instead of just outputting like #ColList# i need to > output like this: > > #ColListItem1#, #ColListItem2#, #ColListItem3#, and so on... > > No then, the added problem is this.... I wont know how many items there are > to output. there maybe 1, 4, 10 or 50 so i need to dynamically output > individual list items. > > How on earth can i achive this? Does anyone know how this can be done? > > many thanks > z > > P.S. i can of course give more info if needed. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:5246 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
