|Keep It Simple, Stupid|
Re: Querying Select Number of Rowsby chipmunk (Parson)
|on Jun 05, 2001 at 08:08 UTC||Need Help??|
Why can't you use that if fewer than 11 rows are returned? That code will work just fine, regardless of the number of rows.
You want to select the oldest 11 rows (after a certain date), without ordering by date and time... But if you don't order by date and time, how do you know which are the oldest??
To fill out your code a little more:
The most important thing here is adding rows to the results list one at a time, and stopping if you get to 11.