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
Conferences
Stylus Studio Feature Requests
(1192)
Stylus Studio Technical Forum
(14621)
Website Feedback
(249)
XSLT Help and Discussion
(7625)
XQuery Help and Discussion
(2017)
Little Help :)))
(2)
Xquery tag position
(2)
Can I connect to MonetDB/XQuer...
(1)
Is there a way to format a num...
(2)
Please help convert SQL query ...
(3)
Connect to SQL Server Express ...
(3)
Convert HTML to XML within C# ...
(1)
return different result based ...
(7)
Java Heap Space
(2)
XQuery Results export to multi...
(3)
NO RETURN
(5)
Part of a csv into a current X...
(3)
How to escape ampersand in xqu...
(2)
How to Convert CSV lines to in...
(5)
Data connection Stylus Studio ...
(2)
Nested XQuery FLOWRs with RDBM...
(3)
observing xquery at work
(2)
alternative for 'exists'
(4)
Xquery and webpages how?
(2)
Help with another DataDirect p...
(5)
Previous
[121-140]
[141-160]
[161-180]
Next
Stylus Studio FAQs
(159)
Stylus Studio Code Samples & Utilities
(364)
Stylus Studio Announcements
(113)
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 !!!!
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.