Snippet from WikiNotesProvider.java:
case KEYWORD_SEARCH:
// this match searches for a text match in the body of notes
qb.setTables("keywords");
qb.setProjectionMap(KEYWORDS_LIST_PROJECTION_MAP);
qb.appendWhere("body like ? or title like ?");
whereArgs = new String[2];
whereArgs[0] = whereArgs[1] = "%" + uri.getLastPathSegment() +
"%";
break;
- Juan T.
On Oct 17, 10:36 am, Premier <[EMAIL PROTECTED]> wrote:
> The problem is '%?%' .
> It doesn't recognize that string.
>
> On 17 Ott, 12:48, Mark Murphy <[EMAIL PROTECTED]> wrote:
>
> > Premier wrote:
> > > Hello world,
> > >likein object, i want to useLIKEexpression in Android
>
> > > [CODE]
> > > private SQLiteDatabase db;
> > > ...
> > > Cursor resultCursor= null;
> > > resultCursor= db.query(false, DB_TABLE, null, "idlike%"+id+"%",
> > > null, null, null, null, null);
> > > ...
> > > [/CODE]
>
> > I have not triedLIKEfrom 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
-~----------~----~----~----~------~----~------~--~---
