Sudarshan TR wrote: > Your statements here are not clear. Adding ORDER BY fieldnam ASC should > not cause the query to stop returning results. > > > Suppose I employ the method '*query*' part of SQLiteDatabase Class, I > get a Cursor returned to me, which I can convert into a ListAdapter > using a SimpleCursorAdapter and then proceed to displaying it as a list > on the phone.
Correct. > How do I show the items from my database as a list on the screen if I > use an execSQL to execute a query such as '*select * from numbers order > by name_or_num asc;' *?? Don't use execSQL() for queries. The query() method helps build your query from component parts; rawQuery() lets you hand it a hunk of plain SQL. If you don't like one, use the other. They both return a Cursor. If there is something you are doing that you think execSQL() will do but rawQuery() won't, write back! -- Mark Murphy (a Commons Guy) http://commonsware.com Warescription: All titles, revisions, & ebook formats, just $35/year --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Beginners" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] Announcing the new M5 SDK! http://android-developers.blogspot.com/2008/02/android-sdk-m5-rc14-now-available.html For more options, visit this group at http://groups.google.com/group/android-beginners?hl=en -~----------~----~----~----~------~----~------~--~---
