Hi,

>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>'>

Try this:

<@ROWS>
         <@ADDROWs ARRAY="local$vSixColumns" VALUE="<@ARRAY VALUE='<@VAR 
MailArray[<@CURROW>,2]>,<@VAR MailArray[<@CURROW>,3]>,<@VAR 
MailArray[<@CURROW>,5]>,<@VAR MailArray[<@CURROW>,6]>,<@VAR 
MailArray[<@CURROW>,7]>,<@VAR MailArray[<@CURROW>,8]>,<@CRLF>;">
</@ROWS>



>But all I get is a one column array.

That's because your @ARRAY has several errors. First, if you specify a 
VALUE attribute, you don't need to specify ROWS and COLS attributes. The 
@ARRAY tag will figure out the dimensions based on the data in the VALUE 
attribute. Second, you need to specify row and column delimiters in the 
VALUE attribute. The defaults are comma and semi-colon, respectively. 
Third, @@MailArray[*,2] will return an array. You can do that in a VALUE 
attribute of an @ARRAY tag, but only once. You are trying to create an 
array from SIX separate arrays. Even if you separated them by commas, it 
would never work.

Start reading up on the @ARRAY tag. You'll figure them out soon and life 
will be much better.

Eric


________________________________________________________________________
TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED]
                with unsubscribe witango-talk in the message body

Reply via email to