You have a set of nested cfoutput tags. you don't need the inner set. <cfoutput> <cfset i = i + 1> ChapterArray#category#[#i#] = #category#; ChapterArrayVal#category#[#i#] = "#catno# #category#"; </cfoutput> </cfoutput>
Also, you are getting a variable from category from 2 different dbs in your query, and returning both as category. How are you going to distinguish between these tow columns? Don't you want to name one differently? (Also true for catno and parent_level) SELECT a.category, a.catno, a.parent_level, b.category, b.catno, b.parent_level FROM category_menu a, category_menu b Jerry Johnson ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
