Here's and (old) version of my CountHelper class that automatically creates COUNT statements for SelectQuery. I used to do same for EJBQL, but that was much harder. http://osdir.com/ml/user-cayenne-apache/2009-09/msg00012.html
2010/1/20 Andreas Hartmann <[email protected]> > Hi everyone, > > I'm mainly using SelectQuery queries, built using quite a complex > programmatic infrastructure. But now I have the requirement to obtain the > total number of rows (to set the Content-Range header in a REST service). > > So basically I have a SelectQuery which does > > SELECT … FROM foo WHERE <whereClause> LIMIT … OFFSET …; > > and I need > > SELECT count(*) FROM foo WHERE <whereClause>; > > Is there a straightforward way to build such a query based on the > SelectQuery's expression? I tried Expression.toEJBQL() but faced a couple of > problems which have already been described on this list (e.g. the > likeIgnoreCase issue). > > Do I really have to build a string-based SQL or EJBQL query from scratch? > > Thanks a lot for any hints! > > Best regards, > Andreas > > > > -- > Andreas Hartmann, CTO > BeCompany GmbH > http://www.becompany.ch > Tel.: +41 (0) 43 818 57 01 > > -- Andrey
