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 » Manipulation of XQuery output!!
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 (2016)
-> - Issue with Processing Instruct... (1)
-> + 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
Raghav TulshibagwaleSubject: Manipulation of XQuery output!!
Author: Raghav Tulshibagwale
Date: 17 Nov 2008 02:57 PM
Hello ...

I have the following code as a query ..
"
let $cust :=doc("customers.xml")/Customer-Information/Customer

for $x in $cust
let $y := $x/cust_phn_numbers

return <p>{$x} has phones {$y}</p>

"

If I use the above code it gives me correct answer, but has the <p></p> tags for every customer. I want the answer without the tags. If I remove the tags it gives error.

Can anyone put some light on how to solve the issue??

Also let me know how to get the results on subsequent lines instead of the results displayed one after the other??
Postnext
Minollo I.Subject: Manipulation of XQuery output!!
Author: Minollo I.
Date: 17 Nov 2008 03:23 PM
...
return ($x,"has phones",$y)
Postnext
Raghav TulshibagwaleSubject: Manipulation of XQuery output!!
Author: Raghav Tulshibagwale
Date: 17 Nov 2008 11:17 PM
Originally Posted: 17 Nov 2008 10:46 PM
Thank you for the solution!!


I am getting the output, but with one after the other. I want one result on one line. How to make use of next line and carriage return character in the result to get the desired output??

Output Right now I am getting
XYZ has phone 123-234-2232 PQR has phone 332-334-5555

Desired output
XYZ has phone 123-432-2232
PQR has phone 332-334-5555
Posttop
Minollo I.Subject: Manipulation of XQuery output!!
Author: Minollo I.
Date: 19 Nov 2008 03:51 PM
See http://www.stylusstudio.com/ssdn/default.asp?action=9&read=8129&fid=57

   
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.