On Oct 11, 8:14 pm, westmeadboy <[email protected]> wrote: > I have an SQL which uses something like "LIMIT 100". > > If the cursor returns 100 rows, is there an efficient way of > distinguishing between whether the LIMIT caused it or not? > > Hmm, I suppose I could just call LIMIT 101 instead but I was hoping > for a nicer way...
You can either select count(*) beforehand to know the total rows, or if you're paging through the whole table then the next page when you run it with "offset 100" you won't get any rows back if there were <100 rows to begin with. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" 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/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
