I have several instances where I need to group by more than one condition.
For example, I create a sales report where I show BY DAY the total of
orders and their status (shipped, cancelled, etc). I'm already grouping by
day to get the daily totals, how can I also group by status? As it is, I
do a separate day-grouped query for each status and output each one into a
structure that I then display (and graph)...
Another example is inventory. I have products of varying conditions in
different types of locations. I want to show a table of condition/location
like this:
Online Overstock
New 56 355
Used 34 234
Crap 34 39
I can do one query and group by condition (I have to sum the quantity from
multiple inventory locations to get that one number, that's where my group
function goes). Then I have to do another query to group by type of
location. But that gives me separate totals like this:
Online 124
Overstock 628
and
New 411
Used 268
Crap 73
Any ideas?
Tony Schreiber, Senior Partner Man and Machine, Limited
mailto:[EMAIL PROTECTED] http://www.technocraft.com
http://www.simplemessageboard.com ___Free Forum Software for Cold Fusion
http://www.is300.net ___________The Enthusiast's Home of the Lexus IS300
http://www.digitacamera.com ______________DigitA Camera Scripts and Tips
http://www.linklabexchange.com _____________Miata Link ECU Data Exchange
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
