This query calls a function in the database that gets the sum of the items
returned with a category id 9 and a valid transaction number.
The problem is that it returns one value for each item in the list of those
ordered. What i need is to just show the total once.
<cfquery name="qGetCatTotal" datasource="RStore">
select ROL.getusercategoriestotal(#transaction#, 9);
</cfquery>
Returns this ...
qGetCatTotal - query - Top 1 of 1 Rows
GETUSERCATEGORIESTOTAL
1 648
648
qGetCatTotal - query - Top 1 of 1 Rows
GETUSERCATEGORIESTOTAL
1 648
648
qGetCatTotal - query - Top 1 of 1 Rows
GETUSERCATEGORIESTOTAL
1 648
648
qGetCatTotal - query - Top 1 of 1 Rows
GETUSERCATEGORIESTOTAL
1 648
648
The 648 is right.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 by Adobe®
Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7.
Free Trial. http://www.adobe.com/products/coldfusion
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270505
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
