XML Editor
Sign up for a WebBoard account Sign Up Keyword Search Search More Options... Options
Chat Rooms Chat Help Help News News Log in to WebBoard Log in Not Logged in
Show tree view Topic
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
Postnext
Michael NevinsSubject: Node depth limit with MySQL?
Author: Michael Nevins
Date: 20 Aug 2010 02:03 PM
Is there any limit on the number of nested nodes I am allowed to pull data from in Stylus Studio or MySQL?

I seem to be unable to retrieve data below a nest of 12 deep.



Michael A. Nevins
Northrop Grumman
Electronic Systems

Postnext
Ivan PedruzziSubject: Node depth limit with MySQL?
Author: Ivan Pedruzzi
Date: 20 Aug 2010 04:11 PM

There is no limitation.

Could you share a concrete case?

Are you working with XML type columns?

Ivan Pedruzzi
Stylus Studio Team

Postnext
Michael NevinsSubject: Node depth limit with MySQL?
Author: Michael Nevins
Date: 21 Aug 2010 10:16 AM
I am using normal datatypes, what ever that means. I will attach the .sql dump, the XML file that the output must replicate and the XQuery code as I have it so far.

When I get to the deepest "Structure" element in this nest I get no data or even the element. The data is in the database and I believe I have it indexed properly. What do you suggest?

Thanks,



Michael A. Nevins
Northrop Grumman
Electronic Systems


UnknownTest_EN2T.xml


UnknownEN2TAug20_1.xquery


UnknownEN2T.sql

Postnext
Ivan PedruzziSubject: Node depth limit with MySQL?
Author: Ivan Pedruzzi
Date: 25 Aug 2010 12:44 PM
Hi Micheal,

The element "structure" has a sub element called FK_Data.

The following loop seems to work.

for $structure1 in $structure
where $element/PrimaryKey = $structure1/FK_Data
return

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

Posttop
Michael NevinsSubject: Node depth limit with MySQL?
Author: Michael Nevins
Date: 25 Aug 2010 05:16 PM
Yes, But I need the $structure1/FK_Element not FK_Data since that is where the data I need is stored. Something here is not right.

Michael A. Nevins
Northrop Grumman
Electronic Systems

 
Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Go to previous topicPrev TopicGo to next topicNext Topic
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.