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:5244 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
