Re: [bdbxml] Restricting result set

John Snelson <[email protected]> Fri, 23 Sep 2005 12:51:01 +0100
Newsgroups gmane.comp.db.dbxml.general
Message-ID <[email protected]>
You can wrap the query in the "subsequence()" function, like this:

subsequence(collection(), 1, 100)

which means "get 100 results starting at result 1".

You can also use lazy results, and just call XmlResults::next() as many 
times as you need results.

John

Antony Grinyer wrote:
> Is there any way to restrict the number of results added to the result
> set brought back from queries to the DB XML Java API? It's probably
> possible through XQuery to control the number of result returned,
> however I was wondering if there is any way to all a query/result set
> with a parameter? (without having to do any programming iterating the
> result set to restrict the number of record returned/displayed) 
> 
> Thanks,
> Ant
> 
> 
> 
> 
> ------------------------------------------
> To remove yourself from this list, send an
> email to [email protected]
> 


-- 
John Snelson, Berkeley DB XML Engineer
Sleepycat Software, Inc
http://www.sleepycat.com

Contracted to Sleepycat through Parthenon Computing Ltd
http://blog.parthcomp.com/dbxml


------------------------------------------
To remove yourself from this list, send an
email to [email protected]