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 » Stylus Studio Technical Forum » Attribute - XSD, DataDirect, XQuery and XML output
Conferences Close Tree View
+ Stylus Studio Feature Requests (1192)
- Stylus Studio Technical Forum (14621)
-> + DBF converter with the Cyrilli... (3)
-> + Stylus Studio caching document... (3)
-> + Stylus Studio Online help inst... (9)
-> + specific colors (2)
-> + Formatting problems when creat... (2)
-> - Headers and Footers (1)
-> + XML output's a URL in Browser ... (2)
-> + Generating Java Code for XML (3)
-> + format dates in publisher (2)
-> + grouping in Stylus Studio Publ... (5)
-> + Can schema documentation title... (3)
-> + Stylus can not find the right ... (2)
-> + Problem to create Schema from ... (5)
-> - Design a DTD to represent the ... (1)
-> + Surround SCM integration (3)
-> + Converting a csv file to xml u... (5)
-> + Legacy Format Handling (3)
-> + Size limit for XML documents (2)
-> + Can Stylus Studio easily expor... (3)
-> + Problem convert excel to xml (5)
-> + convert X12 EDI into XML in a... (2)
-> + Capturing the return data for ... (3)
-> + stamps.com wsdl issues (3)
-> + Preview issues (2)
-> + Stylus Studio X14 - XML to EDI... (3)
-> + Stylus Studio X14 - Overrides ... (4)
-> + Anyway to specify namespace pr... (6)
-> + StylusStudio 2010 crashes when... (6)
-> + Version Upgrade (2)
-> + How to write a if -else statem... (4)
-> + URGENT URGENT URGENT ! (EDIF... (3)
-> + X14 Saxon document uri problem (5)
-> + namespace problem on XML gener... (7)
-> + Stylus Studio Tool Bars (2)
-> + X14 Enterprise - Web Services ... (3)
-> + Saxon edition in X14 Enterpris... (2)
-> + How to create PDF documents wi... (2)
-> + WSCall doesn't work from xquer... (4)
-> + Issues with converter (8)
-> + xsd null strings - option to i... (2)
-> + wrapping table rows and mismat... (3)
-> + Report Designer: Is it possibl... (4)
-> + Message Baplie 1.5 with 1.911 ... (2)
-> + saved merged view in diff engi... (2)
-> + Cannot see needed element to m... (2)
-> + Matching problem in function (3)
-> - Funny warning message (1)
-> - Missing rows and text when con... (1)
-> + Another JSON problem (2)
-> + JSON problem (8)
-> + WebDav Custom properties (2)
-> + jvm not registering in the too... (2)
-> + How to turn off error about mi... (6)
-> + XML Attribute Element output f... (2)
-> + ddtek:wscall not returning all... (7)
-> - Trial Only Lasted 7 of the 14 ... (1)
-> + tree view without leaves (fiel... (3)
-> + XML to Text File (2)
-> + Stylus Studio Processor Debugg... (3)
-> + Java XMLPipeline result to str... (6)
-> - Attribute - XSD, DataDirect, X... (7)
-> ->Attribute - XSD, DataDire...
-> ->Attribute - XSD, DataDire...
-> ->Attribute - XSD, DataDire...
-> ->Attribute - XSD, DataDire...
-> ->Attribute - XSD, DataDire...
-> ->Attribute - XSD, DataDire...
-> + .NET XslCompliedTransform pro... (3)
-> + How to increase JVM Heap Size? (10)
-> + How in XSD do I reference the ... (2)
-> + Conversion of negative numbers (2)
-> + XSLT mapper (2)
-> - Converting csv file with embed... (1)
-> + WSDL completion inquiry (2)
-> - Move License (1)
-> + XML to Excel conversion and vi... (8)
-> + “spell checker” and “well-form... (2)
-> + Relational DB Icon Not appeari... (2)
-> + How come AUP doesn't respond (4)
-> - Software activation does not w... (1)
-> + Stylus studio continually cras... (2)
-> + Error running on Windows 7 (3)
-> + Creating xml start and end tag... (4)
-> + Keeping track of position afte... (3)
-> + splitting a row into multiple ... (3)
-> + Where is Convert to XML? (2)
-> + Built-In XSLT Processor Missin... (4)
-> - Converting XSL to XSL-FO (1)
-> - Can we compare two XML Schema ... (1)
-> - Stylus Studio EDI Conversion /... (1)
-> + Installation Issue Windows XP ... (2)
-> + Converting CSV with component ... (2)
-> - how to edit a xsl file, so tha... (1)
-> - Cannot save file to Webdav (1)
-> + How to copy Column Names on Gr... (3)
-> - XML when to use (1)
-> - Attribute vs data elements (1)
-> - Attribute Group (1)
-> - EDI conversion from command li... (1)
-> - WSDL schema - import of xsd (1)
-> + Get Date (2)
-> + help calling https web service (5)
-> - Newbie looking out for BizTalk... (1)
-> + Publishing XML pipeline as Web... (2)
-> - annotation within sequence ele... (1)
-> - backmapping using Saxonica 9.1... (1)
-- Previous [301-320] [321-340] [341-360] Next
+ Website Feedback (249)
+ XSLT Help and Discussion (7625)
+ XQuery Help and Discussion (2017)
+ Stylus Studio FAQs (159)
+ Stylus Studio Code Samples & Utilities (364)
+ Stylus Studio Announcements (113)
Topic  
Postnext
Mary VallesSubject: Attribute - XSD, DataDirect, XQuery and XML output
Author: Mary Valles
Date: 04 Aug 2011 01:22 PM
I am new to Stylus and XML and really need help.

I have a project that contains a XQuery (mapped to SQL Server data) and an XSD file.

I have attached the following sample files:
Test.xsd
Test - current.xml
Test - Desired.xml


I need to have each attribute value in a seperate XML record versus all together.


DocumentTest-Desired.txt


DocumentTest-current.xml


Documenttest(6).xsd
Postnext
Ivan PedruzziSubject: Attribute - XSD, DataDirect, XQuery and XML output
Author: Ivan Pedruzzi
Date: 04 Aug 2011 02:20 PM
Hi Mary,

My guess is that the query does not iterate through the repeating element.
We need to see the XQuery code in order to help.

Ivan
Postnext
Mary VallesSubject: Attribute - XSD, DataDirect, XQuery and XML output
Author: Mary Valles
Date: 04 Aug 2011 02:51 PM
Can I e-mail the code and files to you?
Postnext
Mary VallesSubject: Attribute - XSD, DataDirect, XQuery and XML output
Author: Mary Valles
Date: 04 Aug 2011 02:57 PM
I have attached the actual XQuery and XSD files. If you need to see the XML output please let me know.


DocumentMEVXQuery.xquery


DocumentMEV.xsd
Postnext
Ivan PedruzziSubject: Attribute - XSD, DataDirect, XQuery and XML output
Author: Ivan Pedruzzi
Date: 04 Aug 2011 03:40 PM
May,

I can see several problems

What you are trying to accomplish with the following? Do you need to generate a Transactional or a DTOApplication element for each record in the XML_Application?

for $_x0058_ML_Application in collection("MSRB_Test_be.dbo.XML_Application")/_x0058_ML_Application/AppModID
return
<Transactional>
{
for $_x0058_ML_Application2 in collection("MSRB_Test_be.dbo.XML_Application")/_x0058_ML_Application/ApplicationNumber
return



In regards of the duplicate attribute values, see the following changes

for $_x0058_ML_Application2 in collection("MSRB_Test_be.dbo.XML_Application")/_x0058_ML_Application
return
<DTOApplication
ApplicationNumber="{ $_x0058_ML_Application2/ApplicationNumber}"
CustomerRef="{$_x0058_ML_Application2/CustomerRef}"
Description="{$_x0058_ML_Application2/Description}"

... and several others


Every time you see a call to the collection function inside an attribute value you should be suspicious.



The following where statement also sounds suspicious, it should express a relationship between the tables XML_Building and XML_Line

for $_x0058_ML_Building in collection("MSRB_Test_be.dbo.XML_Building")/_x0058_ML_Building
where collection("MSRB_Test_be.dbo.XML_Line")/_x0058_ML_Line




Hope this helps
Ivan
Postnext
Mary VallesSubject: Attribute - XSD, DataDirect, XQuery and XML output
Author: Mary Valles
Date: 04 Aug 2011 04:02 PM
Yes, the objective is a single Transactional element for each record returned in XML_Application.

Thanks so much for you help. I will look at the items you pointed out snd see how far I get.

I may be back asking for more help! :)
Posttop
Mary VallesSubject: Attribute - XSD, DataDirect, XQuery and XML output
Author: Mary Valles
Date: 04 Aug 2011 06:43 PM
Thanks so much Ivan...you saved my life!!!
   
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.