Another thing we do, although maybe it wouldn't work for you, is to issue <@purgeresults> in an action and then display the data as needed in the next action, and then export <@results> to a file to be opened in Excel.
----- Original Message ----- From: "Tom Ferguson" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Tuesday, January 17, 2006 2:31 PM Subject: RE: Witango-Talk: Need some ideas > 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 > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
