i have a simple update statement that isn't executed at all. i have no idea what's the matter. got no error.
var db = Ti.Database.open('mydb'); var sql = 'UPDATE db SET imageURL=\"'+url+ '\" WHERE id='+id; Ti.API.info(sql); db.execute(sql); db.close();
the database is already installed. damn it
Why do you escape the quotes?
var sql = 'UPDATE db SET imageURL="'+url+ '" WHERE id='+id;
hm.. it doesn't execute the statement although i don't escape the quotes. if i execute the statement with an other program like the sqlite database browser it is working fine.