Beefy Boxes and Bandwidth Generously Provided by pair Networks
XP is just a number
 
PerlMonks  

Re: Querying Select Number of Rows

by runrig (Abbot)
on Jun 05, 2001 at 03:24 UTC ( #85660=note: print w/ replies, xml ) Need Help??


in reply to Querying Select Number of Rows

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.


Comment on Re: Querying Select Number of Rows

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://85660]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (7)
As of 2015-07-05 12:56 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (66 votes), past polls