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 » Create multiple XML Files
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
Emma SmithSubject: Create multiple XML Files
Author: Emma Smith
Date: 19 Feb 2008 07:37 AM
I need to create an xml file for each record returned in a SQL Query - is this possible?
Postnext
Minollo I.Subject: Create multiple XML Files
Author: Minollo I.
Date: 19 Feb 2008 08:43 AM
It is possible using DataDirect XQuery (no need to specify SQL queries); for example, you can do something like this:

for $booksXML in collection("Books.dbo.booksXML")/booksXML
where contains($booksXML/title, "XML")
return
ddtek:serialize-to-url($booksXML, concat("file:///c:/myXMLBooks/", $booksXML/isbn, ".xml"), "")

That will create an XML file (named after the book's ISBN number) for each record in the database matching the condition that the book's title contains the word "XML".
Postnext
Emma SmithSubject: Create multiple XML Files
Author: Emma Smith
Date: 19 Feb 2008 09:31 AM
Thanks for that - if I only wanted to return certain columns for each record and create a separate xml file - how do I do this.

Thanks again
Postnext
Minollo I.Subject: Create multiple XML Files
Author: Minollo I.
Date: 19 Feb 2008 09:37 AM
You have all the flexibility of XQuery in your hands... You can completely control what you serialize; for example, to just output the "title" column wrapped in a "<myBook>" element, you can do:

for $booksXML in collection("Books.dbo.booksXML")/booksXML
where contains($booksXML/title, "XML")
return
ddtek:serialize-to-url(<myBook>{$booksXML/title}</myBook>,
concat("file:///c:/myXMLBooks/", $booksXML/isbn, ".xml"), "")
Posttop
Emma SmithSubject: Create multiple XML Files
Author: Emma Smith
Date: 19 Feb 2008 09:42 AM
Brilliant - thanks for your quick response
   
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.