I am having trouble filtering the SQLite data with two conditions. I keep getting an unrecognized token error and I suspect that my query statement might be incorrect in the script. Could you please take a look and see if you can help me out? Thank you! I have attempted two different ways to do this:
getEquipmentByTagCode(equipTag,projCode){
console.log("Equipment Param"+equipTag+projCode);
return this.database.executeSql('SELECT * FROM equipmentInstall WHERE equipTag=('+equipTag+') AND projCode=('+projCode+') ', []);
}
getEquipmentByTagCode(equipTag,projCode){
console.log("Equipment Param"+equipTag+projCode);
return this.database.executeSql('SELECT * FROM equipmentInstall WHERE equipTag IN ('+equipTag+') AND projCode IN ('+projCode+') ', []);
}