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.
