Re: Witango-Talk: Need some ideas

Alan Wolfe Tue, 17 Jan 2006 14:57:38 -0800

sorry made a little typo.

<@rows array=request$myarray>

that should read:

<@rows>

---------- Forwarded message ----------
From: Alan Wolfe <[EMAIL PROTECTED]>
Date: Jan 17, 2006 2:55 PM
Subject: Re: Witango-Talk: Need some ideas
To: witango-talk@witango.com

nope you don't have to build an array (:

try this and it should come out something like you want, just put this in where you would normaly put your @@resultset to make an xls file:

<@rows array=request$myarray>

<tr>

</tr>

<tr>

</tr>

</table>

Give it a try and let us know if that gives you anything close to what you want (:

On 1/17/06, Tom Ferguson <[EMAIL PROTECTED]> wrote:

that sounds like it would work, but I'm not smart enough to do it... :)

Don't I have to build an array?
From: Alan Wolfe [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 17, 2006 05:43

To: witango-talk@witango.com
Subject: Re: Witango-Talk: Need some ideas

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
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Need some ideas

Reply via email to