Does anyone have any suggestions on how to insert data into a SQLite
DB in AIR if the data being inserted or updated contains single or
double quotes using a token based update string like this:
UPDATE SITE SET name='{0}',description='{1}', url='{2}'
If I use a statement helper to create my update statement like this:
public static function create(statement:String, ...args) : String
{
return StringUtil.substitute(statement, args);
}
and a single quote is in the description (for example) the update
statement fails. If I change the above UPDATE statement to look like this:
UPDATE SITE SET name="{0}",description="{1}", url="{2}"
I can use single quotes in my arguments but I can't use double quotes
in my arguments. Any advice?
