The <cfheader has an error because I deleted some code. It should read
<cfheader name="Content-Disposition" value="attachment;
filename=#attributes.name#.xls">
-----Original Message-----
From: Pascal Peters
Sent: donderdag 11 september 2003 16:16
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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics.
http://www.fusionauthority.com/signup.cfm
