That's what I'm doing now. I need to be able to manipulate that result set. Take out Field 4 and put it into a new row between rows 1 and 2, etc. But I'm pretty sure I can't have an array where there aren't the same number of columns in each row. Not like you can do in HTML with the "colspan=x"
> -----Original Message----- > From: Dave Machin [mailto:[EMAIL PROTECTED] > Sent: Tuesday, January 17, 2006 05:27 > To: [email protected] > Subject: Re: Witango-Talk: Need some ideas > > One thing we do is write @@resultset to a file, leaving it > formatted as an HTML table; but name it with a .XLS extension. > Excel is pretty good at loading an HTML table of data and > keeping all the data in the right cells. Or is that what > you're already doing? > > > > ----- Original Message ----- > From: "Tom Ferguson" <[EMAIL PROTECTED]> > To: <[email protected]> > Sent: Tuesday, January 17, 2006 2:13 PM > Subject: RE: Witango-Talk: Need some ideas > > > > BTW, I can do this to a web page, no problem. My problem > is getting it > into > > an array so I can write it to a spreadsheet. Guess I don't do array > process > > enough. > > > > > -----Original Message----- > > > From: Tom Ferguson [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, January 17, 2006 04:57 > > > To: [email protected] > > > Subject: Witango-Talk: Need some ideas > > > > > > I have a SQL table similar to this: > > > > > > Field1 | Field2 | Field3 | Field4 | Field5 > > > > > > I currently let Witango read the table into ResultSet, add > > > some column headers with <@AddRows>, then write the ResultSet > > > to an Excel file that the client can download as a spreadsheet. > > > > > > In this particular instance, however, Field 4 is very long, > > > 8000 characters max and most get used. > > > > > > What the client would like to see is this: > > > > > > | Field1 | Field2 | Field3 | Field5 | > > > | Field4 | > > > | (empty row) | > > > | Field1 | Field2 | Field3 | Field5 | > > > | Field4 | > > > | | > > > | Field1 | Field2 | Field3 | Field5 | > > > | Field4 | > > > | | > > > > > > Any suggestions? > > > > > > TIA > > > > > > Tom Ferguson > > > > > > > > > > > > Thomas Ferguson > > > Vice President > > > Enroll DR, LLC > > > 710 94th Ave. N. #304 > > > St. Petersburg, Florida 33701 > > > > > > www.enrolldr.com > > > > > > ______________________________________________________________ > > > __________ > > > TO UNSUBSCRIBE: Go to > http://www.witango.com/developer/maillist.taf > > > > > > > > ______________________________________________________________ > __________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > > > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
