You could use <@delrows> to remove rows 1 to 57 and 90 on. Then you're left with 58 to 89.
Dave > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Nathan Hitchcock > Sent: Thursday, May 09, 2002 6:27 PM > To: Multiple recipients of list witango-talk > Subject: RE: Witango-Talk: Selecting rows x through y of an array > > > But filter against what? I was unable to find an expression for row # > > X. I guess the alternative would be to have the SQL statement > generate row numbers so that they would be included in the resultset. > The search action is already a direct DBMS so it wouldn't be a big > deal. That way I could say: > > <@FILTER ARRAY="resultSet" SCOPE="local" EXPR="(#1>58) and (#1<90)"> > > Assuming column 1 of the result set was a sequential row number, this > would yield rows 59-89 of the array. > > So that begs the question, what's the SQL statement for getting row > numbers returned with your resultset? (MSSQL 7.0) > > Nathan Hitchcock > HLI Systems > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Johansen > Sent: Thursday, May 09, 2002 3:03 PM > To: Multiple recipients of list witango-talk > Subject: RE: Witango-Talk: Selecting rows x through y of an array > > > Use the <@FILTER> meta tag > > Ben Johansen - http://www.pcforge.com > Authorized WiTango Reseller > http://www.pcforge.com/WiTangoGoodies.htm > latest beta downloads @ http://www.witango.ws > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Nathan Hitchcock > Sent: Thursday, May 09, 2002 12:51 PM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: Selecting rows x through y of an array > > > Hello List, > > What's the easiest way to take a group of rows in an array and assign > them to a new array? For example, taking rows 59-89 in array_1 and > assigning just those 30 to a new array_2. There must be something > with less overhead than looping through the array using the start and > stop parameters of an <@ROWS> instance. > > Any thoughts? > > > Nathan Hitchcock > HLI Systems > > ______________________________________________________________________ > __ > 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 > > ________________________________________________________________________ > 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
