Re: How-to execute a query from an ESP script?

[Bertrand Delacretaz]

Hi Gert,

On Mon, Apr 14, 2008 at 4:22 PM, Gert Vanthienen
<[EMAIL PROTECTED]> wrote:
> ... The subject basically covers the entire question: I would like to execute 
> a
> JCR query from within an ESP page to get a set of nodes in the order I want
> (descending by date created).  How can I do this?...

We don't have an example yet, but that would look something like

 var statement = ...jackrabbit query statement
 var language = ...jackrabbit query language selection

 var resolver = request.getResourceResolver();
 results = resolver.queryResources(statement, language);

 while(results.hasNext()) {
    count++;
    var row = results.next();
    var path = row.get('jcr:path');
    var title = row.get("title");
...
  }

-Bertrand