On 9 April 2013 16:57, Scott Aron Bloom <scott.bl...@onshorecs.com> 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, for example by binding a string parameter then making your query do the work of splitting it but they're pretty nasty. If you choose to go down this route then be careful you don't inadvertently introduce an SQL injection problem. > > I would do a “IN (:id1,:id2,:id3)” and have multiple binds That works, though it will reduce the effectiveness of the query cache (assuming your database does this). Cheers Rich. _______________________________________________ Interest mailing list Interest@qt-project.org http://lists.qt-project.org/mailman/listinfo/interest
