Sorry, I mis-copied the name of the first example object. It should be statement_withOUT_var, obviously:

It is about a certain select statement including an IN-clause. It only works with a constant query statement like this: tntdb::Statement statement_with_var = db.prepare("select distinct entry_id" " from index_terms" " where entry_id in (1,2,3,8)");
…while the parameterised version does not yield any result:
tntdb::Statement statement_with_var = db.prepare("select distinct entry_id" " from index_terms" " where entry_id in (:subset)"); //followed by statement_with_var.set("subset", "1,2,3,8").select(), of course

Attachment: pgpm1XkM3UvwO.pgp
Description: PGP signature

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
_______________________________________________
Tntnet-general mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/tntnet-general

Reply via email to