Also, my result set in this instance is 176,000 records.
Do you have a better idea for this? Here are my problems:
A) I need to structure data like this:
Jan 07 | Dec 07 | Nov 07
Pay Type --------------------------------------------
Miles $5 | $0 | $7
Bonus $5 | $0 | $7
Stops $5 | $0 | $7
Etc.. $5 | $0 | $7
B) I need to show the classes in a specific pre-defined order (not
alphabetically)
C) I need to ensure a 0 value shows for a column even of no pay of that
type exists for that year / month
Chris Peterson
-----Original Message-----
From: Brad Wood [mailto:[EMAIL PROTECTED]
Sent: Friday, January 26, 2007 3:53 PM
To: CF-Talk
Subject: RE: QoQ question - anyone know any tricks?
How large is your result set? Keep in mind that QofQ's aren't very
performance friendly once you get near 100,000 records.
You may have to do some manual iterating with cfloop instead of a QofQ
~Brad
-----Original Message-----
From: Peterson, Chris [mailto:[EMAIL PROTECTED]
Sent: Friday, January 26, 2007 2:43 PM
To: CF-Talk
Subject: QoQ question - anyone know any tricks?
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs
http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267786
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
