Hereby a simple method:
<cfcontent type="application/vnd.ms-excel">
<h2>Polling statistics: #stprops_pollingdata.question#</h2>
<table border="1" cellpadding="1" cellspacing="2">
<tr>
<th>Date / Time created</th>
<th>Question</th>
<cfloop index="i" from="1" to="#application['wsoFarcryPolling'
& pollingid]#">
<cfif stprops_pollingdata['answer' & i] GT 0>
<th>#stprops_pollingdata['answer' & i]#</th>
</cfif>
</cfloop>
<th>Total votes</th>
</tr>
<tr>
<td>#stprops_pollingdata.datetimecreated#</td>
<td>#stprops_pollingdata.question#</td>
<cfloop index="i" from="1" to="#application['wsoFarcryPolling'
& pollingid]#">
<cfif stprops_pollingdata['answer' & i] GT 0>
<td>#sums[i].recordcount#</td>
</cfif>
</cfloop>
<td>#answers_sum#</td>
</tr>
</table>
On Nov 3, 12:57 am, Marco van den Oever <[EMAIL PROTECTED]>
wrote:
> Is there a function to put db data in Excel???
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"farcry-dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/farcry-dev?hl=en
-~----------~----~----~----~------~----~------~--~---