Re: [Interest] QSQLQuery bindValue to SELECT WHERE IN

2013-04-09 Thread Richard Moore
On 9 April 2013 16:57, Scott Aron Bloom wrote: > It will depend the server backend.. However in general, I have never been > successful (not just in Qt, at all) in binding for “lists” That's correct, a bound parameter can only hold a single value. There are some evil tricks you can do however, fo

Re: [Interest] QSQLQuery bindValue to SELECT WHERE IN

2013-04-09 Thread Scott Aron Bloom
It will depend the server backend.. However in general, I have never been successful (not just in Qt, at all) in binding for "lists" I would do a "IN (:id1,:id2,:id3)" and have multiple binds Scott From: interest-bounces+scott.bloom=onshorecs@qt-project.org [mailto:interest-bounces+scott.