How about explicitly specifying all columns in the order by?
ORDER BY Package,price,Company,City,Project_id
HTH,
Steve
At 05:53 PM 6/20/2000 -0700, Chris Giminez wrote:
>I'm joining a few tables and grouping them by their "package". It works
>great until I try to add an ORDER BY price statement to the sql.
>When I do that, it creates several groups. The pricing order takes
>precedence over the grouping done in CF. How can I order by price and stay
>within the groups?
>
>thanks!
>______________________________
>
><CFQUERY NAME="bid_package_results" DATASOURCE="scbuild">
>SELECT contractors.company_name as company, contractors.city,
>bid_results.price, bid_results.project_id, bid_packages.label as package
>FROM bid_packages, contractors, bid_results
>WHERE bid_packages.package_id = bid_results.package_id AND
> contractors.contractor_id = bid_results.bid_id AND
> (bid_results.project_id = #form.project_result#)
>
></CFQUERY>
>
>
>
><cfoutput query="bid_package_results" group="package">
>
><tr><th align="left">#package#</th></tr>
><cfoutput>
><tr><td>#company#</td><td>#city#</td><td>#price#</td></tr>
>
></cfoutput>
>
>
></cfoutput>
>
>
>--
>
>
>Chris Giminez
>Owner - Cyber Scriber Web Site Design
>831-728-4469
>ICQ# 2628000
>
>
>---------------------------------------------------------------------------
---
>Archives: http://www.eGroups.com/list/cf-talk
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
--
Stephen Garrett
GPS
[EMAIL PROTECTED] (360) 896-2714
ICQ# 10776767
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
