Wouldn't you just SELECT xxx FIRST 100 ?
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Thursday, February 18, 2010 9:38 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TOP/LIMIT Equivalent? No that reply wasn't paying attention to the point that we were *sorting* the list. True if you simply Sample the list, they are in random hashed order. But that is not true is the list comes into your program sorted by you execute a sort as the first statement in your program. No you do not have to re-sort it every time the user hits "Next Page". The sorted list is saved as sorted in your workspace, or with a pointer to a set-aside area where it has just been sorted, and *stays* sorted while the user is working through the pages. When the user hits next page, you, the programmer, simply reads the next item in the *already sorted* list... or the next 100 items, and displays that result. Very trivial. I can do it in my sleep, I've done it a hundred times... wait what are we talking about. OK anyway. There are a few gotchas if we're discussing a user-display (as opposed to some behind-the-scenes operation). I'd be willing to work with you, for the price of a ham sandwich! I've been living in a cardboard box for the past year. I take it you have little to no experience in this type of language. Are you the sole programmer for your outfit? Wouldn't it be better to get some contract help at least to work out these issues? Will Johnson Slow and Backward Cardboard Box Technologies http://www.tinyurl.com/ffthome _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users