sqliteappcelerator-titanium

Appcelerator SQLite Like Operator syntax

I'm using appcelerator and working with appcelerator studio, however I'm confused of using the like operator in query string in appcelerator 

 values = Alloy.Globals.database_file.execute('select ChapterID,ChapterCode,ChapterName,ChapterOwner,ChapterOrder,ChapterDescription,ChapterNote,ParentChapterID from CbahiHSChapters like "%' searchText '%"');

quotes are placed incorrect.

Solution

  • Everything looks fine but you are missing + signs like this and where condition

    values = Alloy.Globals.database_file.execute('select ChapterID,ChapterCode,ChapterName,ChapterOwner,ChapterOrder,ChapterDescription,ChapterNote,ParentChapterID from CbahiHSChapters where like "%' + searchText + '%"');