Hello all, I have a column [ lvl ] being returned in a query that is a Count [ count(child.startbranch) AS lvl ]of another column. I need to be able to find the MAX of the returned column so that I can write colspans into a table I am building.
Is there a way to get *essentially* MAX(lvl) in my cfoutput? Desired result: A table that builds itself dynamically so the end result will look like this td colspan=*max(lvl)* - lvl (here it'll be 0)> 0 level header /td/tr td> ,/td td colspan=*max(lvl)* - lvl (here it'll be 1)> 1 level subhead /td/tr etc. so far the data I need to display is 5 levels deep but that number is variable with new subs. TIA will ---- William H. Bowen Webmaster ALSTOM's T&D Energy Automation & Information Business "Your friendly neighborhood Webmaster" [EMAIL PROTECTED] http://www.esca.com/ 425.739.3629 Voice 425.466.7016 Cell 425.739.3690 FAX ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
