Hi, Bibek after changing query like
try
{
sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME,
MODE_PRIVATE, null);
Cursor c23 = sampleDB.query(SWITCH_TABLE_NAME, new
String[]
{"SwitchID"}, "RoomID = "+rID ,null, null, null, null);
int count = c23.getCount();
System.out.println ("Total is"+count);
}
catch (SQLiteException se )
{
se.printStackTrace();
}
Problem is solved.
Thanks
On Nov 17, 11:07 am, "pramod.deore" <[email protected]> wrote:
> Hi Bibek Thanks,
> I had tried it as
>
> public int getCurrentSwitchID(int rID)
> {
> System.out.println ("Here rID is"+rID);
> try
> {
> sampleDB = this.openOrCreateDatabase(SAMPLE_DBNAME,
> MODE_PRIVATE, null);
>
> Cursor c23 = sampleDB.query(SWITCH_TABLE_NAME, new
> String[]
> {"SwitchID"}, null, null, null, null, "RoomID =
> 'rID'");
>
> int count = c23.getCount();
> System.out.println ("Total is"+count); //but here it
> prints
> all rows count
> }
> catch (SQLiteException se )
> {
> se.printStackTrace();
> }
>
> return sid;
> }
>
> when I print count values from cursor then it prints total number of
> rows insted pf printing number of rows whose RoomId is say 3.
>
> On Nov 17, 10:33 am, Kumar Bibek <[email protected]> wrote:
>
> > Read up about simple SQL Statements and then you can use the sampleDB's
> > query method to get a cursor.
>
> > On Wed, Nov 17, 2010 at 10:59 AM, pramod.deore
> > <[email protected]>wrote:
>
> > > I have a table like
>
> > > sampleDB.execSQL("CREATE TABLE IF NOT EXISTS " +
> > > SWITCH_TABLE_NAME +
> > > "(SwitchID integer primary key
> > > autoincrement,SwitchName VARCHAR,RoomID integer,RoomName VARCHAR);");
>
> > > sampleDB.execSQL("INSERT INTO " +
> > > SWITCH_TABLE_NAME +
> > > " Values
> > > (null,'"+switchName+"','"+roomID+"','"+roomName
> > > +"');");
>
> > > Now I want list of all switchName whose roomId say suppose 3. How to
> > > do this?
>
> > > --
> > > 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]<android-developers%[email protected]>
> > > For more options, visit this group at
> > >http://groups.google.com/group/android-developers?hl=en
>
> > --
> > Kumar Bibekhttp://techdroid.kbeanie.comhttp://www.kbeanie.com
>
>
--
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
