Awesome thanks - I am suffering weekend brain
damage.
----- Original Message -----
Sent: Saturday, December 14, 2002 3:54
PM
Subject: RE: Witango-Talk: array
different
Brad,
If
you really want stuff that doesn't appear in either array, <@random>
will usually work. :)
If
you want elements from one array that are not in the other array you can use
<@filter>.
<@filter array=array1 expr="!(@@array2 contains #1)"> (this
assumes both arrays have 1 column )
If
you want elements from either array that are not in both arrays, you can use
the above <@filter> twice and add the results
together.
<@assign local$array3 <@filter array=array1 expr="!(@@array2
contains #1)">>
<@addrows array=local$array3 value=<@filter
array=array2 expr="!(@@array1 contains
#1)">>
Unfortunately the server will throw an
error processing empty arrays, so you may want to test for empty before using
<@filter> or <@addrows>.
Dave Shelley.
-----Original Message----- From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Brad J. Robertson Sent: Saturday, December 14, 2002
4:41 PM To: Multiple recipients of list
witango-talk Subject: Witango-Talk: array
different
Hello,
Is there a metatag that takes 2 arrays and
creates an array of the records that don't appear in either array? A
reverse @union.
Tango2000
IIS 5
Win2000
SQL 7
Brad
|