Awesome, I don't know that I ever would have found that. My only question is does anyone know if there are plans to make the LIMIT functionality a requirement for all JCR implementations? In other words so it will be portable among all JSR-170 compliant repositories? Thanks again, Brett
-----Original Message----- From: Martin Zdila [mailto:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 3:31 PM To: [email protected] Subject: Re: LIMIT in SQL queries hi brett final Query query = session.getWorkspace().getQueryManager().createQuery(queryString, Query.XPATH); ((QueryImpl) query).setLimit(limit); ((QueryImpl) query).setOffset(offset); final QueryResult queryResult = query.execute(); final long totalSize = ((QueryResultImpl) queryResult).getTotalSize(); cu On Fri 28. March 2008 20:27:25 Conoly, Brett wrote: > Hey all, > > I'm currently trying to implement a method that will return a > NodeIterator from the repository based on an SQL query that I pass it. > The only problem right now is that I can't seem to find the equivalent > of the SQL LIMIT function. Does anyone happen to know if there is > equivalent functionality or an alternative to do what I'm looking for? > > Thanks in advance, > > Brett -- Martin Zdila CTO M-Way Solutions Slovakia s.r.o. Letna 27, 040 01 Kosice Slovakia tel:+421-908-363-848 mailto:[EMAIL PROTECTED] http://www.mwaysolutions.com xmpp:[EMAIL PROTECTED] (Jabber) skype:m.zdila
