have you tried doing an <@rows> on this array and outputing it to a file in the format you want in an html table, naming it with a .xls extension?
ie just doing the same as you would with @@request$resultset, but rolling your own table to look like you want?
On 1/17/06, Tom Ferguson <[EMAIL PROTECTED]> wrote:
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: witango-talk@witango.com
> 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: < witango-talk@witango.com>
> 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: witango-talk@witango.com
> > > 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
