The SQL padwan bows to greater wisdom. Avoiding combinig aggregates and
'real' data is a rule of thumb I picked up somewhere. It may have just been
to keep me from botching things when I really didn't know /anything/ about
SQL. :-)
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: Dave Watts [mailto:[EMAIL PROTECTED]
: Sent: Tuesday, March 11, 2003 10:09 PM
: To: CF-Talk
: Subject: RE: distinct count
:
:
: > Ben wrote:
: >
: > "Remember -- it's generally a bad idea to run a query
: > selecting real data and aggregates (like count) at the
: > same time."
: >
: > Then how do I get both the aggregate info and the other
: > query columns I need for the same output?
:
: I disagree with the statement that it's a bad idea to run a query
: selecting
: real data and aggregates at the same time - if you want to ask a question
: like "how many sales per region", that's how you do it.
:
: Dave Watts, CTO, Fig Leaf Software
: http://www.figleaf.com/
: voice: (202) 797-5496
: fax: (202) 797-5444
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
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
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
