The problem is '%?%' .
It doesn't recognize that string.
On 17 Ott, 12:48, Mark Murphy <[EMAIL PROTECTED]> wrote:
> Premier wrote:
> > Hello world,
> > like in object, i want to use LIKE expression in Android
>
> > [CODE]
> > private SQLiteDatabase db;
> > ...
> > Cursor resultCursor= null;
> > resultCursor= db.query(false, DB_TABLE, null, "id like %"+id+"%",
> > null, null, null, null, null);
> > ...
> > [/CODE]
>
> I have not tried LIKE from within Android. SQLite definitely supports
> it, as I have used it from outside Android.
>
> You may need to switch to rawQuery().
>
> --
> Mark Murphy (a Commons Guy)http://commonsware.com
> _The Busy Coder's Guide to Android Development_ Version 1.3 Published!
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
