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
-~----------~----~----~----~------~----~------~--~---

Reply via email to