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

[Sujan Dasmahapatra]

Sometimes the interger variables don't work. Instead try using a QString it should work.

Kind regards,


Sujan Dasmahapatra
Project Leader, Aero Group
CE - Aero Group

Tel  +91 80 66470248
Mob  
sdh at lmwindpower.com


LM Wind Power Blades
lmwindpower.com

Together we capture the wind to power a cleaner world


This e-mail and any attachments are confidential. If you are not the named or intended recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information in any medium. Any unauthorized disclosure, use or storage is prohibited and might be unlawful.
-----Original Message-----
From: qt-interest-bounces+sdh=lmwindpower.com at qt.nokia.com [mailto:qt-interest-bounces+sdh=lmwindpower.com at qt.nokia.com] On Behalf Of Francesco Lamonica
Sent: Tuesday, January 03, 2012 2:33 PM
To: Qt Interest List
Subject: [Qt-interest] problem with bindValue() in nested queries

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?
_______________________________________________
Qt-interest mailing list
Qt-interest at qt.nokia.com
http://lists.qt.nokia.com/mailman/listinfo/qt-interest