XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
smuks srinSubject: dynamic order by clause
Author: smuks srin
Date: 26 Aug 2005 10:01 AM
declare variable $orderby as xs:string external;
declare variable $name as xs:string external;
for $b in //abc
where $b/name=$name
order by $b/$orderby

The orderby is dynamic name received from saxon (for example: age) used for sorting the result, unfortunately the sorting does not occur using the above syntax.

Postnext
Alberto MassariSubject: Re: dynamic order by clause
Author: Alberto Massari
Date: 26 Aug 2005 10:45 AM
If you need to sort on a dynamic node, you can try using

order by $b/*[name()=$orderby]

Hope this helps,
Alberto


Posttop
smuks srinSubject: Re: dynamic order by clause
Author: smuks srin
Date: 26 Aug 2005 10:49 AM
Thanks a lot pal.
Cheers.

 
Go to previous topicPrev TopicGo to next topicNext Topic
Download A Free Trial of Stylus Studio 6 XML Professional Edition Today! Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!  
go

Log In Options

Site Map | Privacy Policy | Terms of Use | Trademarks
Stylus Scoop XML Newsletter:
W3C Member
Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2011 All Rights Reserved.