XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
search
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Home » Boards » Stylus Studio Developer Network » XQuery Help and Discussion » Cleanup and combine question
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
+ Stylus Studio Technical Forum (14621)
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
- XQuery Help and Discussion (2017)
-> + Issue with Processing Instruct... (2)
-> + problem converting json to XML... (2)
-> + Problem base64 decoding string... (3)
-> + Problems posting multipart for... (5)
-> + trouble with download of price... (2)
-> + Problem with http-post not bei... (3)
-> + path problem, xps_file:writeAl... (9)
-> + Xquery update support? (2)
-> + problem with Stylus studio try... (5)
-> + adding dtd reference to xml ou... (4)
-> + xquery escaping ambarsand when... (3)
-> + Whitespace problem when return... (5)
-> + Problem with namespace prefix ... (5)
-> - Sending via SFTP returns unexp... (1)
-> + Query and Sftp clent (4)
-> + xquery and try - catch (3)
-> + Query + ddtek:http-post optio... (5)
-> + Example files referenced in do... (3)
-> + Automatic Error Detection and ... (3)
-> + Working with result of ddtek:h... (2)
-- [1-20] [21-40] [41-60] Next
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Doug LundinSubject: Cleanup and combine question
Author: Doug Lundin
Date: 27 Sep 2006 12:02 PM
I have a query that returns a single value (below) and I have two questions regarding it. First, can it be reformatted so the namespace-uri is stated only once - to cleanup the xquery? Second, I want to add another value on the return set - given by another xpath - how can I modify this xquery to return two values?

Thanks!

/*[local-name()='html' and namespace-uri() 'http://www.w3.org/1999/xhtml']/*[local-name()='body' and namespace-uri()='http://www.w3.org/1999/xhtml'][1]/*[local-name()='div' and namespace-uri()='http://www.w3.org/1999/xhtml'][1]/*[local-name()='div'
and namespace-uri()='http://www.w3.org/1999/xhtml'][3]/*[local-name()='table' and namespace-uri()='http://www.w3.org/1999/xhtml'][2]/*[local-name()='tr' and namespace-uri()='http://www.w3.org/1999/xhtml'][1]/*[local-name()='td' and namespace-uri()='http://www.w3.org/1999/xhtml'][2]/text()[1]

Postnext
Ivan PedruzziSubject: Cleanup and combine question
Author: Ivan Pedruzzi
Date: 27 Sep 2006 02:40 PM
i Doug,

What you have posted is an XPath expression. In which context are you trying to use it?

XPath Query Editor
XQuery
XSLT

In the XPath Query Editor you should use the re-defined prefix value by default ns1, ns2, ect.

So you query becomes
/nsi:html[1]/ns1:body[1]/ns1:div[1]/ns1:div[1]/ns1:table[2]/ns1:tr[1]/ns1:td[1]

In a similar way in XSLT and XQuery you will need to associate the namespace to a prefix then use the prefix to qualify you XPath expression

Hope this helps
Ivan Pedruzzi
Stylus Studio Team
Posttop
Doug LundinSubject: Cleanup and combine question
Author: Doug Lundin
Date: 27 Sep 2006 03:16 PM
Thanks for your reply, Ivan,

I reformatted given your suggestion and have a solution - thanks!

declare namespace a = "http://www.w3.org/1999/xhtml";
<CompanyMetadata>
<AvgVol>
{/a:html/a:body[1]/a:div[1]/a:div[3]/a:table[2]/a:tr[1]/a:td[1]/a:table[3]/a:tr[1]/a:td[3]/a:table[1]/a:tr[1]/a:td[1]/a:table[1]/a:tr[4]/a:td[2]/text()}
</AvgVol>
(... more junk cut out here)
</CompanyMetadata>

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