Rather than grouping in SQL, you might just sort by price and then use
CFLOOP to run through them, breaking them into groups of $50k where
appropriate.
-- Ben Doom
Programmer & General Lackey
Moonbow Software, Inc
: -----Original Message-----
: From: Brad Roberts [mailto:[EMAIL PROTECTED]
: Sent: Wednesday, March 26, 2003 5:16 PM
: To: CF-Talk
: Subject: SOT: SQL
:
:
: I've got a price column in an Access DB. I'm wondering how to include the
: price rounded to the nearest 50,000 in my query.
:
: I'm basically wanting to group the output by price in $50,000 increments.
: If there's a better way, I'm open to that, too.
:
: For instance:
:
: 250,000 and under
: .....
: 200,000 and under
: .....
: 150,000 and under
: ....
:
: Thanks.
:
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
