no need to hard-code the col names. you can get the column names with a sql statement. there's a 'new fangled' way of doing this in cf8 as well
here's the high-level of how i'd approach this. my code would 1. select the column names 2. loop through the column names in step one and 2a. run additional SELECT * sql statements to select all of the data 3. use ben's code to output each statement from step 2 into a new worksheet Regards, Chris - Christopher Vigliotti Sr ColdFusion Developer Goldbelt Raven On 1/2/08, Tech Gate <[EMAIL PROTECTED]> wrote: > > Thank you, Chris. > > I need to download all of the tables regardless the order of columns > since the order of columns are not important. In that case, I will > not need to hard-code the column names as to there are a ton of column > names. Do you know of solutions for this? > > Thx much > > On Jan 2, 2008 9:46 AM, Christopher Vigliotti <[EMAIL PROTECTED]> > wrote: > > this may be helpful to you >> > > > http://www.bennadel.com/blog/474-ColdFusion-Component-Wrapper-For-POI-To-Read-And-Write-Excel-Files.htm > > > > - Christopher Vigliotti > > Sr ColdFusion Developer > > Goldbelt Raven > > > > > > On 1/2/08, Tech Gate <[EMAIL PROTECTED]> wrote: > > > > > > I have a dozen of tables in the sql 2000 db, and need to extract ALL > > > rows of the tables with ALL column names into one Excel file (with a > > > dozen of Worksheets) through cf page so that users can download the > > > entire db as needed. > > > > > > thx much > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295709 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
