Thank you! That did the trick.
On Apr 19, 4:52 pm, Dmitri Plotnikov <[email protected]> wrote: > You need to escape the mime type. > > Better yet, do this: > > Cursor cursor = mResolver.query( Data.CONTENT_URI, > new String[]{Event.DISPLAY_NAME, Event.DATA}, > Data.MIMETYPE + "=? AND " + Event.TYPE + "=?", > new String[]{Event.CONTENT_ITEM_TYPE , > String.valueOf(Event.TYPE_BIRTHDAY)}, > Data.DISPLAY_NAME ); > > > > > > On Sat, Apr 17, 2010 at 8:37 AM, JohnT <[email protected]> wrote: > > Hello, > > > I'm using Dmitri's code but am getting the following error: > > > ERROR/AndroidRuntime(529): Caused by: > > android.database.sqlite.SQLiteException: near ".": syntax error: , > > while compiling: > > SELECT display_name, data1 > > FROM view_data_restricted data > > WHERE (1) AND (mimetype=vnd.android.cursor.item/contact_event AND > > data2=3) > > ORDER BY display_name > > > Anyone know what could be causing this? > > > On Mar 11, 2:50 pm, Dmitri Plotnikov <[email protected]> wrote: > > > Nice, but this might be even better: > > > > Cursor cursor = mResolver.query( Data.CONTENT_URI, > > > new String[]{Event.DISPLAY_NAME, Event.DATA}, > > > Data.MIMETYPE + "=" + Event.CONTENT_ITEM_TYPE + " AND " + Event.TYPE > > + > > > "=" + Event.TYPE_BIRTHDAY, > > > null, > > > Data.DISPLAY_NAME ); > > > if( cursor != null ) { > > > try { > > > while( cursor.moveToNext() ) { > > > String displayName = cursor.getString(0); > > > String date =cursor.getString(1); > > > } > > > } finally { > > > cursor.close(); > > > } > > > > } > > > On Wed, Mar 10, 2010 at 11:12 PM, Karan <[email protected]> wrote: > > > > Use the following code to read the data. > > > > > Cursor cursor = mResolver.query( Data.CONTENT_URI, null, where, null, > > > > Data.DISPLAY_NAME ); > > > > if( cursor != null ) { > > > > while( cursor.moveToNext() ) { > > > > String rawContactID = > > > > cursor.getString( cursor.getColumnIndex( Data.RAW_CONTACT_ID ) ); > > > > String mimetype = > > > > cursor.getString( cursor.getColumnIndex( ContactsContract.Data.MIMETYPE > > ) > > > > ); > > > > if( mimetype.equals( StructuredName.CONTENT_ITEM_TYPE ) ) { > > > > // Read name : Field = StructuredName.DISPLAY_NAME > > > > } > > > > else if( mimetype.equals( Relation.CONTENT_ITEM_TYPE ) ) { > > > > // Read birthdate : Field = Relation.DATA > > > > } > > > > // Note : The name and the birthday will be there in different > > > > entries > > > > // So make sure that you match them properly and maintain it > > > > accordingly > > > > } > > > > } > > > > > On Mar 10, 11:38 pm, Mark Murphy <[email protected]> wrote: > > > > > Nox wrote: > > > > > > Thank you for your replies, > > > > > > but unfortunately it doesn t work. > > > > > > If I open my app there ll appear the error message: > > > > > > > The application has stopped unexpectedly. Please try again. > > > > > > > Do you know what I have to do now? > > > > > > Use adb logcat, DDMS, or the DDMS perspective in Eclipse to look at > > the > > > > > Java stack trace that was generated when that dialog appeared. It > > should > > > > > give you some clues for fixing your problem. > > > > > > -- > > > > > Mark Murphy (a Commons Guy)http://commonsware.com| > > > >http://twitter.com/commonsguy > > > > > > _The Busy Coder's Guide to *Advanced* Android Development_ > > > > > Version 1.3 Available! > > > > > -- > > > > 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%2Bunsubs > > > > [email protected]><android-developers%2Bunsubs > > [email protected]> > > > > 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 [email protected] > > To unsubscribe from this group, send email to > > [email protected]<android-developers%2Bunsubs > > [email protected]> > > 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 [email protected] > To unsubscribe from this group, send email to > [email protected] > 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 [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
