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