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 >>>>> >>>> >>> >>
