SSDN - dynamic order by clause

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

smuks srin

Subject: 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.

(Deleted User)

Subject: Re: dynamic order by clause
Author: (Deleted User)
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

smuks srin

Subject: Re: dynamic order by clause
Author: smuks srin
Date: 26 Aug 2005 10:49 AM

Thanks a lot pal.
Cheers.

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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-2016 All Rights Reserved.