Nothing about this sounds particularly odd or undoable... I would recommend taking a gander at sql GROUP BY clause and <cfoutput> group="attribute" ... You might be able to accomplish the whole thing simply by using grouped output with your cfoutput tags. :) After all, it was intended for just this sort of thing. :)
Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 > Ok..it's like this. > This is an EXTREMELY simplified version of the page. This > is for a > report. > In one instance, I want to loop over several Team Names. > One Service > Area could have say..20 Teams. > So the report will show team 1--totals...Team 2--Totals > etc. etc. > OR! > The user could just select ONE team, and then display that > one Team. > So, the CFIF was to check if the user had selected a > Service Area, or > just a Team. If it's a Service Area then display each > table with all the > calculations etc. 20 times if necessary using a CFLOOP > Query. > Otherwise, just do all that stuff once. > The entire page with all the HTML table formatting, > Javascript > calculations etc. is about 300 lines long. > I'd have preferred to just do everything in one report, > rather than have > to submit to a Team report , or a Service Area report > which is just > using the same damned code, with just two extra lines. > <CFLOOP query="Service Area"> > </CFLOOP> > So..thats what I want to do..that was my thinking. And > apparently I > can't do it..I might as well just make two separate > reports. > -Gel > From: Phoeun Pha > Subject: RE: Looping depending on CFIF Statement > Date: Thu, 29 Aug 2002 08:27:20 -0700 > __________________________________________________________ > ____________ > Structure your ColdFusion code with Fusebox. Get the > official book at http://www.fusionauthority.com/bkinfo.cfm > FAQ: http://www.thenetprofits.co.uk/coldfusion/faq > Archives: > http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: > http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists