XQuery Help

[jhagemeier]

Hello,

I'm looking for some help with an xquery.

My XML looks like this:

<EmailContentData>
<EMAIL>[email protected]</EMAIL>
<GPP_NBR>1111222233334444</GPP_NBR>
<!-- other elements here -->
</EmailContentData>

I need to create an xquery that will return ALL the nodes within the
<EmailContentData> in concatenated string form, with a little bit of
formating. Like this:

'&[email protected]&GPP_NBR=1111222233334444'

The difficulty I'm having is figuring out how to generically
concatenate data across multiple nodes without referencing the node
names directly. I need the xq to be generic because the
<EmailContentData> nodes may vary by document.

Any help would be sincerely appreciated.

Thanks,
Jeff

 

[Martin Honnen]

My XML looks like this:

<EmailContentData>
<EMAIL>[email protected]</EMAIL>
<GPP_NBR>1111222233334444</GPP_NBR>
<!-- other elements here -->
</EmailContentData>

I need to create an xquery that will return ALL the nodes within the
<EmailContentData> in concatenated string form, with a little bit of
formating. Like this:

'&[email protected]&GPP_NBR=1111222233334444'

The difficulty I'm having is figuring out how to generically
concatenate data across multiple nodes without referencing the node
names directly. I need the xq to be generic because the
<EmailContentData> nodes may vary by document.

Here is an example that works for me with Saxon:

declare namespace saxon="http://saxon.sf.net/";
declare option saxonutput "method=text";
concat('&amp;', string-join(for $el in doc('test2008010201.xml')/*/*
return concat(local-name($el), '=', data($el)), '&amp;'))