Re: In the xquery, how do i access the counter in for
You could use the "positional variable" feature of the "for" construct, but you'd get results other than what you want because the "position" is assigned before any filtering by the "where" clause and reordering by the "order by" clause. However, you could use this feature with a nested "for": for $y at $i in (for $x in doc("books.xml")/bookstore/book where $x/price>30 order by $x/title return $x/title) return concat($i, ": ", $y) -Brandon :) On Sun, Jun 19, 2011 at 12:50 AM, sudheshna iyer <sudheshnaiyer@xxxxxxxxx> wrote: > Eg: > for $x in doc("books.xml")/bookstore/book > where $x/price>30 => want the loop counter. > order by $x/title > return $x/title > > If "doc("books.xml")/bookstore/book" returns 3 elements(book1, book2, book3), > and during the looping, I want to get loop counter value. > > For the first element, I want to prepare string using loop counter like > "elem-1", and for the second, I want "elem-2" > > > Thank you for your help.
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format