[Qt-interest] problem with bindValue() in nested queries

[Francesco Lamonica]

Hi all,
i have a piece of code like:

QSqlQuery query,q2;
query.prepare("select * from table1");
query.exec();
while (query.next()) {
int myid = query.record().value("id").toInt();

q2.prepare ("select * from table2 where id=:myid");
q2.bindValue(":myid",myid);
q2.exec(); // <--- this fail

}

the error i get is:
QSqlError(-1, "QPSQL: Unable to create query", "ERROR:  operator does
not exist: integer =?
LINE 1: SELECT * FROM table2 WHERE id=?
                                              ^
HINT:  No operator matches the given name and argument type(s). You
might need to add explicit type casts.
")  for query ( "SELECT * FROM table2 WHERE id=?" )

a few more points:
*) i am sure that myid is correct: qDebug()  prints it out correctly;
*) if i change the query like: q2.prepare("select * from table2 where
id="+QString::number(myid)); everything works
*) if i execute the query outside the while loop it works (test done
setting myid to some sensible number)
*) "external" query does not use any kind of bound values
*) qt is 4.7.4 on linux gentoo (amd64), db is postgresql 9.1.2 (same platform)

any ideas?