Hi all,
Quick (ish) question - what would be a good way to return a recordset and a
total from a cfc?
Perhaps I should show some code:
Old Skool:
<cfquery datasource="blah" name="g">
select monthname,sum(salevalue) as salevalue
from sales
where theyear="2006"
group by monthname
</cfquery>
<cfset thetotal=0>
<table>
<cfoutput query="g">
<cfset thetotal=thetotal+salevalue>
<tr>
<td>#monthname#</td>
<td>#salevalue#</td>
</tr>
</cfoutput>
<tr>
<td>Total</td>
<td><cfoutput>#thetotal#</cfoutput></td>
</tr>
</table>
This is bad because I'm doing calculations in my view - mixing presentation
with code etc.
CFC stylee:
<cfinvoke component="whatever" method="whatever"
returnvariable="somestruct">
<cfoutput>
<table>
<cfloop from="1" to="#variables.somestruct.monthlydata.recordcount#"
index="i">
<tr>
<td>#variables.somestruct.monthlydata.monthname[i]#</td>
<td>#variables.somestruct.monthlydata.salevalue[i]#</td>
</tr>
</cfloop>
<tr>
<td>Total</td>
<td>#variables.somestruct.thetotal#</td>
</tr>
</table>
</cfoutput>
So within my cfc, I loop over the query to calculate the total, and return a
struct of both the recordset and this total.
Is this the right way to go? It looks to me like it'd be slower than the
quick and dirty approach since I'm performing two loops. But I like it
because I'm not doing any calculations mid-<table>.
But would it be better to have 2 functions - getsalesbymonth("2006")
(returns a query) and getsalesforyear("2006") (returns a number) and call
them separately? (This looks like 2 database calls, which is even worse I
suppose.)
Any thoughs appreciated - hope I've not opened a massive can of worms...
Regards,
Geoff
----------------------------------------------------------
You are subscribed to cfcdev. To unsubscribe, send an email to
[email protected] with the words 'unsubscribe cfcdev' as the subject of the
email.
CFCDev is run by CFCZone (www.cfczone.org) and supported by CFXHosting
(www.cfxhosting.com).
An archive of the CFCDev list is available at
www.mail-archive.com/[email protected]
