Re: CF_Query2Excel
on 9/5/02 12:40 PM, Mark W. Breneman at [EMAIL PROTECTED] wrote: > Been there done that and had to get a different tag in the interests of > time. Yep. I ended up using the cf_excel tag by Michael Walsh and works great. thanks sebastian __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_Query2Excel
I modified the cf_query2excel tag to do just that. Let me know off list if your interested in it. Jeff -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 1:27 PM To: CF-Talk Subject: CF_Query2Excel I want to ouput a query to an excel file and am using the custom tag cf_query2excel. When the Excel file is generated the excel headings are not in the same sequence as in the query. For example, the query has in this order 'SponsorName, SponsorID, FirstName, LastName.' But in the Excel file it shows up in the following sequence 'FirstName, LastName, etc.' Any suggestions on how to make the headings appear in the same sequence as the query? thanks Sebastian __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: CF_Query2Excel
Been there done that and had to get a different tag in the interests of time. Found that all of my rows were shifted by one. After digging deeper I found the first column of data was blank and query2excel rather then putting a blank value in would simply skip inserting the column. I started editing query2excel to fix a few problems but then I found a tag called simply "excel" in the tag gal. Excel fixed all of the problems I found. Mark W. Breneman -Macromedia Certified ColdFusion Developer -Network / Web Server Administrator Vivid Media [EMAIL PROTECTED] www.vividmedia.com 608.270.9770 -Original Message- From: sebastian palmigiani [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 12:27 PM To: CF-Talk Subject: CF_Query2Excel I want to ouput a query to an excel file and am using the custom tag cf_query2excel. When the Excel file is generated the excel headings are not in the same sequence as in the query. For example, the query has in this order 'SponsorName, SponsorID, FirstName, LastName.' But in the Excel file it shows up in the following sequence 'FirstName, LastName, etc.' Any suggestions on how to make the headings appear in the same sequence as the query? thanks Sebastian __ 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 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
