Tony, Alternatively, just append the data to a variable as you are looping through with commas as delimiters etc. and then write the variable to the file when you are done.
André -----Original Message----- From: Tony Weeg [mailto:[EMAIL PROTECTED] Sent: 04 September 2003 16:55 To: CF-Talk Subject: RE: query output to Excel file but I could in the same light, write the data as comma delimited inside a cfsavecontent? and then from there...dump the data in the cfsavecontent into the cffile, as one file system hit? tony weeg sr. web applications architect navtrak, inc. [EMAIL PROTECTED] www.navtrak.net office 410.548.2337 fax 410.860.2337 -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 11:34 AM To: CF-Talk Subject: Re: query output to Excel file Tony, You can do anything you need to do in the cf template, writing it out as you would normal html. Excel can open an html file (formatted like a table) and it will "function" exactly like excel. The following code will trick the browser into thinking it's dealing with excel: <CFHEADER NAME="Content-Disposition" VALUE="attachment; filename=sample.xls"> <CFCONTENT TYPE="application/excel"> If you're going to email the file to someone, I would think that you could use cffile to write the content (using cfsavecontent to build the page). -Deanna ----- Original Message ----- From: "Tony Weeg" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, September 04, 2003 10:13 AM Subject: RE: query output to Excel file > trouble is, I cant do it all in 1 query, I have cf logic that HAS to > be there, and it is then emailed to a client :( so, is there a way to > take a cfquery object that is returned, and just dump that into > something, and send it, versus writing line by line by line.... > > tony weeg > sr. web applications architect > navtrak, inc. > [EMAIL PROTECTED] > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Craig Dudley [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 10:53 AM > To: CF-Talk > Subject: RE: query output to Excel file > > > Youre using SQL server yes? > > So DTS would be the best option for that amount of data, Jon Hall > posted all about it a few months back, check the archives. > > -----Original Message----- > From: Tony Weeg [mailto:[EMAIL PROTECTED] > Sent: 04 September 2003 15:54 > To: CF-Talk > Subject: RE: query output to Excel file > > > id love to know myself, I have a query that returns an assload of > data, that I have to write to csv, and now it takes 45 minutes to > complete...there has to be a better way! > > tony weeg > sr. web applications architect > navtrak, inc. > [EMAIL PROTECTED] > www.navtrak.net > office 410.548.2337 > fax 410.860.2337 > > > -----Original Message----- > From: Petr Kysela [mailto:[EMAIL PROTECTED] > Sent: Thursday, September 04, 2003 10:45 AM > To: CF-Talk > Subject: query output to Excel file > > > What would you say is the best way of creating an Excel file from > query data? I don't need to know how to create a .csv file. > > I've seen solutions through ADO objects, ODBC dsn, custom tags, etc. > > But surely there must be something quick and easy. > > Cheers > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
