RE: Witango-Talk: array different

[David Shelley]

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. [EMAIL PROTECTED]   -----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