Figured it out meh self when i was not so friday fubared 

<CFCONTENT type="application/vnd.ms-excel">
<CFHEADER name="Content-Disposition" value="filename=filename.xls">

<CFDUMP VAR = #MYQUERY#>

or i could have done a columlist output loop -  and yay no cfile needed -


----- Original Message ----- 
From: "Paul Fennell" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, December 05, 2003 12:16 PM
Subject: [ cf-dev ] query to excel - 


> Hi ,
> Anybody aware of a different method ( com/customtag ) 
> To take a dynamic query . ( dynamic results set and data )  to create
> and excel file on the fly 
> Or a csv on the fly with out having to go the cffile route of building
> it in code 
> 
> Ie a custom tag that can take a query dump and just drop it as is in to
> excel ?
> 
>  
> 
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.545 / Virus Database: 339 - Release Date: 27/11/2003
>  
> 
> 
> -- 
> ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/
> 
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
> For human help, e-mail: [EMAIL PROTECTED]
> 

Reply via email to