Hello Monica, It seems the query is not correct. Missing quotes for WHERE_MONTH_YEAR The correct query needs to treat WHERE_MONTH_YEAR as variable. It should look like as follows: return mDb.rawQuery("select t_date from finance " + where t_month= +"\'" + selectedMonth + "\' and " + t_year = '"" + selectedYear+"'", null);
Hope this would resolve your problem. ag On May 3, 4:58 pm, Monica Chrismawati <monica.rady...@gmail.com> wrote: > Hi all, > > currently develop an application and when I catch data from database, > the record always incomplete. > I am curios whether this is because I use distinct, but when removed > distinct, the incomplete result also come too. > For the example I query to get all dates using rawQuery: > > public Cursor getAllDates(String selectedMonth, String selectedYear){ > > String WHERE_MONTH_YEAR = "t_month = '"+selectedMonth+"' and > t_year='" + selectedYear+"'"; > return mDb.rawQuery("select t_date from finance where > t_month='"+selectedMonth+"' and t_year = '"+selectedYear+"'", null); > > } > > the call method for the example: getAllDates("June", "2010"); > > when the query execute using command line with query:" select t_date > from finance where t_month='June' and t_year='2010'; > > the result should be: > 7 > 8 > > but in the emulator I get only 8. > > Anybody ever got issue like this? This is because of what? Somebody > please help me, thanks a lot. > > -- > 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 > athttp://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