>but I think that someone mentioned in a >thread last week that was not "here", right?
> -----Original Message----- > From: Mark Adamcin [mailto:[email protected]] > Sent: Tuesday, August 24, 2010 3:37 PM > To: [email protected] > Subject: Re: JCR-SQL2 : paging > > > Clemens, > > I haven't tried it yet myself, but I think that someone mentioned in a > thread last week that you can have a query compute the number > of rows by > ordering by jcr:score. In jcr-sql2, that probably requires > you to include > jcr:score as a column. > > Mark Adamcin > Acquity Group > > > > On Tue, Aug 24, 2010 at 1:17 AM, Clemens Wyss > <[email protected]> wrote: > > > Just to clarify I didn't miss anything in the API doc: > > If I want to provide a paging navigation with a "link per > page" and/or a > > "go to last page" link, then I need to execute the overall > query (in order > > to get the total amount of rows/pages (*)) and then > re-execute the query for > > the current page. > > > > (*) even worse: > > as the RowIterator does not provide the number of rows (at > least not for > > JCR-SQL2), I have to iterate over all rows just to get the > total number of > > rows. Yes, SQL has COUNT but xpath doesn't ( > > https://issues.apache.org/jira/browse/JCR-260), so there is > no generic > > count for the various query languages... > > > > > -----Original Message----- > > > From: Clemens Wyss - MySign AG [mailto:[email protected]] > > > Sent: Wednesday, August 18, 2010 4:05 PM > > > To: '[email protected]' > > > Subject: RE: JCR-SQL2 : paging > > > > > > > > > >Or is there a "JCR pattern" for paging? > > > Query.setLimit and Query.setOffset seem to provide the > > > generic (search language independent) approach for paging. > > > > > > Sorry for the noise... > > > Clemens > > > > > > > -----Original Message----- > > > > From: Clemens Wyss - MySign AG > > > > Sent: Wednesday, August 18, 2010 3:54 PM > > > > To: '[email protected]' > > > > Subject: JCR-SQL2 : paging > > > > > > > > > > > > how would you implement paging with JCR-SQL2? Im looking for > > > > MySQL's LIMIT equivalent. Or is there a "JCR pattern" > for paging? > > > > > > > > Thx in advance > > > > > > > > > >
