I have still the problem. I read at http://books.google.co.in/books?id=2XeNswkT_2YC&pg=PA232&lpg=PA232&dq=order+by+clause+android&source=bl&ots=omdYC77sPU&sig=xsqE8Pp29uTnjVAaxwDbr2vN7Xs&hl=en&ei=wjzqTKaLGMilcMGo_dUK&sa=X&oi=book_result&ct=result&resnum=4&ved=0CCgQ6AEwAzgK#v=onepage&q=order%20by%20clause%20android&f=false
as it write query as constantsCursor = db.rawQuery("SELECT _ID ,title,value" + "FROM constants ORDER BY title",null); I also tried like above Cursor c = sampleDB.rawQuery ("SELECT SwitchID,SwitchName,RoomID,RoomName"+ "From SwitchTable ORDER BY RoomID",null); But still not getting output. On Nov 22, 9:56 am, "pramod.deore" <deore.pramo...@gmail.com> wrote: > I had also tried as > > Cursor c = sampleDB.query(SWITCH_TABLE_NAME, new String[] > {"SwitchID,SwitchName,RoomID,RoomName"}, "RoomID= > ",null,null,null," ASC"); > > But still it is not working.Any clue? > > On Nov 22, 9:13 am, "pramod.deore" <deore.pramo...@gmail.com> wrote: > > > Hi , > > I have a table that has 4 columns.There is no primary key in that > > table. Now I want to retrieve table data according to ascending order > > of one column (say ascending order of RoomID). I had tried it as > > > Cursor c = sampleDB.query(SWITCH_TABLE_NAME, new String[] > > {"SwitchID,SwitchName,RoomID,RoomName"}, > > "RoomID"+ " ASC" ,null, null, null, null); > > > But it doesn't work. Anyone know what is wrong here? > > Thanks > > -- You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to android-developers@googlegroups.com To unsubscribe from this group, send email to android-developers+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/android-developers?hl=en