Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
XQuery Help and Discussion
»
Help with a basic FLWOR query
Topic
Prev Topic
Next Topic
next
Subject:
Help with a basic FLWOR query
Author:
kaustubh misra
Date:
02 Jul 2009 03:50 PM
Hi
I am an Xquery newbie and have a question for the experienced. Probably this is a really simple query but it has me stumped for some time now.
If this is the xml I want to parse:
<root>
<Object>
<element>
<Value>10</Value>
</element>
</Object>
<Object>
<element>
<Value>20</Value>
</element>
</Object>
<Object>
<element>
<Value>30</Value>
</element>
</Object>
</root>
Question: What, then, would be the best way to write a query that would parse and:
a) return the "object" element node with the maximum "value "
b) return just the "value" element with the maximum value of "value"
I hope that at least my question is clear and would appreciate any help with this very basic question.
Thanks so much for your time
-E
next
Subject:
Help with a basic FLWOR query
Author:
Ivan Pedruzzi
Date:
02 Jul 2009 05:36 PM
declare variable $v :=
<root>
<Object>
<element>
<Value>10</Value>
</element>
</Object>
<Object>
<element>
<Value>20</Value>
</element>
</Object>
<Object>
<element>
<Value>30</Value>
</element>
</Object>
</root>;
let $max := fn:max($v/Object/element/Value/text())
return
let $o := $v/Object[element/Value = $max]
return ($o, $o/element/Value)
top
Subject:
Help with a basic FLWOR query
Author:
kaustubh misra
Date:
06 Jul 2009 12:09 PM
Thank you so very much !!!!
Prev Topic
Next Topic
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:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
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.