sql statement not executed
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
2 Answers
-
Why do you escape the quotes?
tryvar 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.