@Mark: could you link me to the mentioned thread? Thx Clemens
> -----Original Message----- > From: Justin Edelson [mailto:[email protected]] > Sent: Tuesday, August 24, 2010 3:50 PM > To: [email protected] > Subject: Re: JCR-SQL2 : paging > > > On 8/24/10 9:47 AM, Clemens Wyss wrote: > >> but I think that someone mentioned in a > >> thread last week > > that was not "here", right? > probably jackrabbit-users. > > > > >> -----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 > >>>>> > >>>> > >>> > >> > >
