I said to myself "Self I Said", I bet that is where he is going with this ;-)
Yes, generating the Row Numbers in the Database ResultSet would be the simplest, or you could include another column in the Search which would uniquely identify the values in rows 58->90 Having a Row count to filter on would be cool :-) 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 3: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
