|
|
|
| laziness, impatience, and hubris | |
| PerlMonks |
Re: Querying Select Number of Rowsby runrig (Abbot) |
| on Jun 05, 2001 at 03:24 UTC ( #85660=note: print w/replies, xml ) | Need Help?? |
|
This must be What are placeholders in DBI, and why would I want to use them? day :)
Just have your fetch loop exit after 11 rows are fetched. That will give you the 11 oldest rows. It shouldn't matter if there are fewer than 11 rows, then the loop will end without an explicit exit. Queries can sometimes be limited to a certain number of rows, but it is database dependent and the syntax varies.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||