>> 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.
Got you. Yeah defaulting to 'created_at', and failing that 'id', seems like a good idea. Tom --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
