On Fri, Mar 13, 2009 at 3:37 AM, Tom Locke <[email protected]> wrote:
> What's the problem exactly? A SELECT without an ORDER BY if a
> perfectly normal thing to do isn't it?
If you don't specify an order, rows are allowed to come back in random
order. This, of course, makes paging impossible (or at least
useless).
You can generally get away with this because MySQL and sqlite tend to
return rows sorted by ID. But this is just a side effect and could
change at any time.
- Scott
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Hobo
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/hobousers?hl=en
-~----------~----~----~----~------~----~------~--~---
