Coincidence! I just posted this this morning:
<CFHEADER NAME="Content-Disposition" VALUE="inline; filename=foo.xls">
<cfcontent type="application/msexcel">
<table border=1>
<cfoutput query="q1">
<tr>
<cfloop list="#q1.columnList#" index="i">
<td
style="width:1in;white-space:nowrap;">#Evaluate("q1.#i#")#</td>
</cfloop>
</tr>
</cfoutput>
</table>
-----Original Message-----
From: Pete Ruckelshaus [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 04, 2007 2:52 PM
To: CF-Talk
Subject: [EMAIL PROTECTED] on generating .XLS from a dynamic query
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265692
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4