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%[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%[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 at
http://groups.google.com/group/android-developers?hl=en
