[Interest] Is chaining of multiple SQL statements with bound values possible?
Guido Seifert
wargand at gmx.de
Mon Mar 16 16:04:54 CET 2015
Hi,
my problem:
When I combine two sql statement in one QSqlQuery:
query("SELECT * FROM foo; SELECT * FROM bar");
it works ok.
But this does not seem to work when the statements have different bound values:
query("SELECT * from foo WHERE name=:foo"; SELECT * from bar WHERE name=:bar");
query.bindValue(":foo",xxx);
query.bindValue(":bar",yyy);
I always get an unspecified syntax error. The statement without the bound values works fine.
Any ideas?
Guido
More information about the Interest
mailing list