Alternatively you can do a standard sql query with the execute() command. I did this when I had trouble combining too many criterias. But I did a similar query line like you in my dbhandler:
dbo::ptr<pointDataT> x = find<pointDataT>().where("job_number = ? and
point_number = ?").bind(j).bind(p);
Tor
10. juli 2014 kl. 04:27 skrev Jeffrey Scott Flesher Gmail
<jeffrey.scott.fles...@gmail.com>:
> 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);
>
>
> Thanks, I looked all over for an example and couldn't find one.
> ------------------------------------------------------------------------------
> 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
> witty-interest@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/witty-interest
signature.asc
Description: Message signed with OpenPGP using GPGMail
------------------------------------------------------------------------------ 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 witty-interest@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/witty-interest
