mercredi 23 mars 2016

Sqlite insert gives syntax error

I am working on flex actionscript project. In which i am going to save/insert records in sqlite database, which i got in response.

But, form that records some records are not inserted into table. When i catch the error it gives sql error.

near '/': syntax error

In response i have got whole html markup.

I have written/execute query inside for loop like:

var insert:SQLStatement = new SQLStatement(); 
insert.sqlConnection = sqlConnectionSync;
insert.text = 'INSERT OR IGNORE INTO TableName (MessageID, AccountID, Body) VALUES ("' + listArray[i].MessageID + '","' + listArray[i].AccountID + '","' + listArray[i].Body + '")';
insert.execute();

I have also tried changing " in place of ' and vice versa.

But it gives other error of '

Error #3115: SQL Error.

near 'll': syntax error

And

near '_blank': syntax error

Any help would greatly appreciated.

Aucun commentaire:

Enregistrer un commentaire