How can I easily nab the SUM of the inventory.service_shipping records
returned in this query via SQL? SUM blah AS cblah tosses an error, I
suppose because just one part is aggregate? Any quick ideas?
<cfquery name="get_productHOLDS" datasource="sddheinz">
SELECT
customer_orders_prod_shiphold.product_id,
customer_orders_prod_shiphold.qty,
customer_orders_prod_shiphold.line_total,
customer_orders_prod_shiphold.order_id,
inventory.service_name,
inventory.service_shipping,
inventory.service_desc
FROM customer_orders_prod_shiphold
LEFT OUTER JOIN inventory on
customer_orders_prod_shiphold.product_id = inventory.service_id
WHERE customer_orders_prod_shiphold.order_id =
<cfqueryparam cfsqltype="cf_sql_integer" value="#order_id#">
</cfquery>
Thanks!
Regards,
Eric J. Hoffman
DataStream Connexion
www.datastreamconnexion.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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.
http://www.cfhosting.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
