SSDN - Format DB xQuery results

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Mike Lucas

Subject: Format DB xQuery results
Author: Mike Lucas
Date: 17 Apr 2009 02:30 PM

I am trying to build an xQuery against three database tables, and return the results in a hierarchy format. My key field across each table is con_id, and the detail table has one or more records for each record in the master table. I can see in my syntax that the format is currently:
<Cons>
<master>
<detail></detail>
<ridr></ridr>
</master>
</Cons>

And I want to change it to:
<Cons>
<master></master>
<detail></detail>
<ridr></ridr>
</Cons>

Everything I've tried has returned syntax errors or told me that line 8 cannot find $m. My xQuery is below.

<Cons>
{
for $m in collection("DB.dbo.master")/master
return
<master>
{ $m/* }
{
for $d in collection("DB.dbo.detail")/detail[con_id = $m/con_id]
return
<detail>
{ $d/* }
</detail>
}
{
for $r in collection("DB.dbo.ridr")/ridr[con_id = $m/con_id]
return
<ridr>
{ $r/* }
</ridr>
}
</master>
}
</Cons>

Thanks,
Mike Lucas

Minollo I.

Subject: Format DB xQuery results
Author: Minollo I.
Date: 17 Apr 2009 05:33 PM

Something like this:
<Cons>
{
for $m in collection("DB.dbo.master")/master
return (
<master>
{ $m/* }
</master>,
for $d in collection("DB.dbo.detail")/detail[con_id = $m/con_id]
return
<detail>
{ $d/* }
</detail>,
for $r in collection("DB.dbo.ridr")/ridr[con_id = $m/con_id]
return
<ridr>
{ $r/* }
</ridr>
)
}
</Cons>

Mike Lucas

Subject: Format DB xQuery results
Author: Mike Lucas
Date: 20 Apr 2009 09:04 AM

Thanks, that did the trick. I've seen parenthesis in other examples, but I've yet to find a good xquery syntax reference site.

Michael

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.