Koen, I think I remember encountering some problem using capitol letters in
"AND". Im not sure, but I had similar query working without capitol letters.
Tor
Sendt fra min iPhone
> Den 11. juli 2014 kl. 10:48 skrev Koen Deforche <[email protected]>:
>
> Hey,
>
> 2014-07-10 4:27 GMT+02:00 Jeffrey Scott Flesher Gmail
> <[email protected]>:
>> select u from video u where categories = 'this' AND language = 'that'
>>
>> These did not work:
>>
>> model->setQuery(session_.query< Wt::Dbo::ptr<TheVideo> >("select u from
>> video u").where("categories = ? AND language =
>> ?").bind(categoryQuery).bind(lang), false);
>>
>> model->setQuery(session_.query< Wt::Dbo::ptr<TheVideo> >("select u from
>> video u").where("categories = ?").bind(categoryQuery).where(language =
>> ?").bind(lang), false);
>
> Both constructs looks right, but perhaps you need to use "u.categories = ?"
> and "u.language = ?"
> What is the error you get?
>
> Regards,
> koen
> ------------------------------------------------------------------------------
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft
> _______________________________________________
> witty-interest mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/witty-interest
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
witty-interest mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/witty-interest