For those not wanting to count out to the 110th character, it's the first "n" of "nodeSet2" just inside of the ISDESCENDANTNODE function.
On Fri, Sep 24, 2010 at 5:01 PM, Carl Hall <[email protected]> wrote: > I've been going in circles on this one. Any help is greatly appreciated. > > I have a query (see below in message) that I can't quite figure out. I > want to return a parent node where any descendant node has a property == > 'tester'. I don't understand why the following message is being returned. > As a side note, if 'AS' is written as 'as', the parser breaks. > > Lexical error at line 1, column 107. Encountered: "n" (110), after : "(" > for statement: for $v in SELECT nodeSet1 FROM [nt:base] AS nodeSet1 INNER > JOIN [nt:base] AS nodeSet2 ON ISDESCENDANTNODE(nodeSet2, nodeSet1) WHERE > nodeSet1.[sling:resourceType] = 'sakai/user-home' and CONTAINS(nodeSet2.*, > 'tester*') ORDER BY SCORE(nodeSet1) return $v >
