Thank, Pascal...

Rick


    >  -----Original Message-----
    >  From: Pascal Peters [mailto:[EMAIL PROTECTED]
    >  Sent: Thursday, September 11, 2003 10:16 AM
    >  To: CF-Talk
    >  Subject: RE: query output to Excel file
    >
    >
    >  <cfcontent type="application/msexcel">
    >  <cfheader name="Content-Disposition" value="attachment;
    >  filename=#attributes.name##.xls">
    >  <cfoutput>
    >  <table border="1">
    >  <tr>
    >   <th>Organisation</th>
    >   <th>Name OCP</th>
    >   <th>Activity</th>
    >   <th>Type</th>
    >   <th>Geoscope</th>
    >   <th>Regiser date</th>
    >  </tr>
    >  <cfloop query="qOrg">
    >  <tr valign="top">
    >   <td>#qORG.ORG_NAME#</td>
    >   <td>#qORG.USR_LASTNAME#, #qOrg.USR_FIRSTNAME#</td>
    >   <td>#qORG.ORG_ACTIVITY#</td>
    >   <td>#qORG.ORG_TYPE#</td>
    >   <td>#qOrg.GEOSCOPE_NAME#</td>
    >   <td>#qOrg.ORG_REGISTER_DATE#</td>
    >  </tr>
    >  </cfloop>
    >  </table>
    >  </cfoutput>
    >  <cfabort>
    >
    >  -----Original Message-----
    >  From: Rick Faircloth [mailto:[EMAIL PROTECTED]
    >  Sent: donderdag 11 september 2003 16:05
    >  To: CF-Talk
    >  Subject: RE: query output to Excel file
    >
    >
    >  What's the code look like for "pushing an ordinary html
    >  table as a file
    >  with an .xls extention using cfcontent"?  Can you give an example for
    >  us?
    >
    >  Rick
    >  ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
    >  ~~~~~~~~|
    >  Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
    >  Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
    >  Unsubscribe:
    >  http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=708.628.4
    >
    >  Your ad could be here. Monies from ads go to support these
    >  lists and provide more resources for the community.
    >  http://www.fusionauthority.com/ads.cfm
    >
    >


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/lists.cfm?link=t:4
Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

This list and all House of Fusion resources hosted by CFHosting.com. The place for 
dependable ColdFusion Hosting.
http://www.cfhosting.com

Reply via email to