Ok, Thanks for your help.
On Nov 22, 4:54 pm, ΠΑΣΧΑΛΗΣ ΠΛΙΑΧΑΣ <plia...@gmail.com> wrote:
> If you work on Eclipse try to read carefully the Console and logCat window,
> maybe there you'll find the answer
>
> Στις 22 Νοεμβρίου 2010 1:38 μ.μ., ο χρήστης pramod.deore <
> deore.pramo...@gmail.com> έγραψε:
>
>
>
> > Hi, ΠΑΣΧΑΛΗΣ ΠΛΙΑΧΑΣ yes it solves my problem. But I don't understand
> > what earlier query not work.
>
> > On Nov 22, 4:28 pm, ΠΑΣΧΑΛΗΣ ΠΛΙΑΧΑΣ <plia...@gmail.com> wrote:
> > > I made this for myself and it works
> > > I created a class named fro example dbFile
> > > public class DbFile {
> > > static Cursor getAll(SQLiteDatabase db) {
> > > return(db.rawQuery("SELECT * FROM TableName ORDER BY ColumnName",
> > > null));
>
> > > }
> > > }
>
> > > and from my activity class i declare
> > > Cursor model=null;
> > > and on create i call:
> > > model=DbFile.getAll(db);
>
> > > 2010/11/22 pramod.deore <deore.pramo...@gmail.com>
>
> > > > I have still the problem. I read at
>
> > > >http://books.google.co.in/books?id=2XeNswkT_2YC&pg=PA232&lpg=PA232&dq.
> > ..
>
> > > > 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<android-developers%2bunsubscr...@googlegroups.com>
> > <android-developers%2bunsubscr...@googlegroups.com<android-developers%252bunsubscr...@googlegroups.com>
>
> > > > For more options, visit this group at
> > > >http://groups.google.com/group/android-developers?hl=en
>
> > --
> > 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<android-developers%2bunsubscr...@googlegroups.com>
> > For more options, visit this group at
> >http://groups.google.com/group/android-developers?hl=en
>
>
--
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
