SSDN - Node depth limit with MySQL?

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Topic Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

Michael Nevins

Subject: 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

Ivan Pedruzzi

Subject: 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

Michael Nevins

Subject: 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

Test_EN2T.xml

EN2TAug20_1.xquery

EN2T.sql

Ivan Pedruzzi

Subject: 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

Michael Nevins

Subject: 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

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 to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

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.