hehe...otherway around..QofQ doesn't work earlier than CF 5...that's why I sent 2 options...mabye you mised the Q of Q one??
Yes ValueList() would work in both....and Dan's approach was more elegant than mine (shoulda taken more than 10 seconds..hehe) ;-) Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Dan Haley" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 12:15 PM Subject: RE: Maximum value of column in cfoutput > We are still on 4.5 ... why won't valuelist work in CF5? > > -----Original Message----- > From: Bryan Stevenson [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, July 23, 2002 12:08 PM > To: CF-Talk > Subject: Re: Maximum value of column in cfoutput > > > and if you're not using CF 5... > > <cfset LevelList = ValueList(YourQuery.Lvl)> > > Then do some list manipulation to get the MAX item in the list > > Bryan Stevenson B.Comm. > VP & Director of E-Commerce Development > Electric Edge Systems Group Inc. > t. 250.920.8830 > e. [EMAIL PROTECTED] > > --------------------------------------------------------- > Macromedia Associate Partner > www.macromedia.com > --------------------------------------------------------- > Vancouver Island ColdFusion Users Group > Founder & Director > www.cfug-vancouverisland.com > ----- Original Message ----- > From: "William H. Bowen" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, July 23, 2002 11:59 AM > Subject: Re: Maximum value of column in cfoutput > > > > Unfortunately I don't need the data in that order, I just need the largest > > value of lvl so that I can use that as the colspan value at the top row of > > my table. > > > > 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 > > ----- Original Message ----- > > From: "Bryan Stevenson" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, July 23, 2002 11:52 AM > > Subject: Re: Maximum value of column in cfoutput > > > > > > > I'm not sure I entirely follow you, but couldn't you ORDER BY lvl DESC > to > > > get the MAX lvl as the first record? > > > > > > Bryan Stevenson B.Comm. > > > VP & Director of E-Commerce Development > > > Electric Edge Systems Group Inc. > > > t. 250.920.8830 > > > e. [EMAIL PROTECTED] > > > > > > --------------------------------------------------------- > > > Macromedia Associate Partner > > > www.macromedia.com > > > --------------------------------------------------------- > > > Vancouver Island ColdFusion Users Group > > > Founder & Director > > > www.cfug-vancouverisland.com > > > ----- Original Message ----- > > > From: "William H. Bowen" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Tuesday, July 23, 2002 11:29 AM > > > Subject: Maximum value of column in cfoutput > > > > > > > > > > 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 > > > > > > > > > > > > > > > ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.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
