Consider: www.adopenstatic.com/experiments/recordsetpaging.asp Methods 1 & 2 both use .GetRows (method 2 uses a temp table in the database). In method 1 however we restrict the number of records coming into our array, which becomes more important as the dataset gets larger.
Cheers Ken ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ From: "Eric Levine" <[EMAIL PROTECTED]> Subject: RE: Paginating an Array using GetRows : Pete, : : Many thanks. : : Regards, : Eric : : -----Original Message----- : From: Pete Lundrigan [mailto:[EMAIL PROTECTED]] : Sent: Friday, October 11, 2002 5:15 PM : To: ActiveServerPages : Subject: RE: Paginating an Array using GetRows : : : http://www.4guysfromrolla.com/webtech/070500-1.shtml : : should get you what you are looking for. : : Pete Lundrigan : Media Resources Center : Academic Web Support : 316.978.7759 : http://www.mrc.twsu.edu/ : [EMAIL PROTECTED] : : : -----Original Message----- : From: Eric Levine [mailto:[EMAIL PROTECTED]] : Sent: Friday, October 11, 2002 4:10 PM : To: ActiveServerPages : Subject: Paginating an Array using GetRows : : Hi all, : : Question.. Has anyone had any luck paginating an array using GetRows? In : the past I have always used the RecordSet object to handle this task : (rs.PageSize, rs.CacheSize, etc), but I have a page that is going to : require the ability to perform bulk updates... I figured using an array : that has an index already built in would be an easy way to keep all the : data and updates in the right spot. : : Any thoughts, tips, links, would be appreciated. : : Regards, : Eric --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
