Thanks for the reply Dave. The problem with combining the sql searches is that it's actually the exact same sql query, just on different data sources. I basically loop through an array of data source names and execute the same query each time. In the results of each, I <@ADDROWS> to create one array. So, I do have the same number of rows and columns.
Thanks, David Green [EMAIL PROTECTED] Systems InSight, Inc. http://www.systemsinsight.com David Shelley wrote: > > David, > > Assuming that the two arrays have the same number of columns and same column > names, you could add the arrays together: > <@addrows array=array1 value="@@array2"> > > then loop through the columns in array 2 and reassign the column headers: > <@for stop=<@numcols array=array2> > <@assign local$array1[0,<@currow>] @@array2[0,<@currow>]> > </@for> > > However if you could combine the 2 searches into one using a criteria > seperator in the search action you could eliminate one search and the need > to add the arrays. > > Dave Shelley > [EMAIL PROTECTED] > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:owner-witango-talk@;witango.com]On Behalf Of David Green > Sent: Monday, November 11, 2002 1:20 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Array Headers... > > Hopefully this is quick and easy... > > I'm doing a couple database searches and then combining them with > <@ADDROWS>. Everything works like it should, but it removes the > original column headers from the search action. > > So I try to re-add them using <@ADDROWS> again, but all I can do is add > at row 1 of the array, not 0. > > Has anyone done this before? Any help is appreciated! > > Thanks, > > David Green > [EMAIL PROTECTED] > Systems InSight, Inc. > http://www.systemsinsight.com > > ________________________________________________________________________ > TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] > with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
