Re: Witango-Talk: Re: Making a 6 Column Array from a 13 columnarray.

[Robert Garcia]

Title: Re: Witango-Talk:  Re: Making a 6 Column Array from a 13 column array.

I don't quite understand what you want to do with the <@crlf>, so I will leave that part out.

First initialize an array with the dimensions you need like so:
<@assign local$vSixColumns <@array cols="6" rows="<@numrows array=local$resultSet>>

Then add the columns you want one at a time:

<@assign local$vSixColumns[*,1] @@local$resultSet[*,2]>
<@assign local$vSixColumns[*,2] @@local$resultSet[*,3]>
<@assign local$vSixColumns[*,3] @@local$resultSet[*,5]>
<@assign local$vSixColumns[*,4] @@local$resultSet[*,6]>
<@assign local$vSixColumns[*,5] @@local$resultSet[*,7]>
<@assign local$vSixColumns[*,6] @@local$resultSet[*,8]>

That should do it, you may also want the name of the columns moved, do this like so:

<@assign local$vSixColumns[0,1] @@local$resultSet[0,2]>
<@assign local$vSixColumns[0,2] @@local$resultSet[0,3]>
<@assign local$vSixColumns[0,3] @@local$resultSet[0,5]>
<@assign local$vSixColumns[0,4] @@local$resultSet[0,6]>
<@assign local$vSixColumns[0,5] @@local$resultSet[0,7]>
<@assign local$vSixColumns[0,6] @@local$resultSet[0,8]>

Voila!
--

Robert Garcia
BigHead Technology
21053 Devonshire Suite 206
Chatsworth, Ca  91311
Phone 818.773.8162
Fax 818.773.8164
http://www.bighead.net/
[EMAIL PROTECTED]


> From: Brian Mowers <[EMAIL PROTECTED]>
> Reply-To: [EMAIL PROTECTED]
> Date: Thu, 09 May 2002 15:41:03 -0400
> To: Multiple recipients of list witango-talk <[EMAIL PROTECTED]>
> Subject: Witango-Talk:  Re: Making a 6 Column Array from a 13 column array.
>
>
> I can't seem to make this one work. I want to create a new 6 column array
> from a 13 column array in a results action.
> I also want to tack on a <@CRLF> at the end of the new array.
> Specifically I want columns 2,3,5,6,7,8  from the resultset array then I
> want to tack on an extra <@CRLF> at the end of it.
>
> Should be simple but this one is giving me fits.
>
> I don't splice and dice arrays, I usually work with <@column>,<@Col Num=n>
> etc.
> I have tried:
> <@assign local$vSixColumns Value='<@ARRAY ROWS=<@NumRows> COLS=6
> VALUE="@@MailArray[*,2] @@MailArray[*,3] @@MailArray[*,5] @@MailArray[*,6]
> @@MailArray[*,7] @@MailArray[*,8]"> <@CRLF>'>
>
>
> But all I get is a one column array.
>
> Best regards,
>
> Brian Mowers
>
>
> ________________________________________________________________________
> TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
>               with unsubscribe witango-talk in the message body
>