cordova/cordova-android — Issue #5: Placeholders not supported
Author: ydanila
Created: 2012-01-18 06:27:26+00:00
State: open

CODE:

function getAutoCompleteData(response, term){
var db = window.openDatabase("data", "1.0", "data", 1000000);
App.term = term;
db.transaction(autocompleteDB, autocompleteDbError, autocompleteDbSuccess);
}

function autocompleteDB(tx) {
tx.executeSql("SELECT * FROM auto where name like '%?%'",
[App.term], success,error);
}

I got error: I/System.out(356): Storage.executeSql(): Error=bind or column index out of range: handle 0x562508

I checked source code for 1.3.0 and found what it just has no support for placeholders.