maria-discuss team mailing list archive

[Björn Hayer <b.hayer@xxxxxxxxxxxxxxx>]

Hi,

I am using CONNECT for some XML files, but lately came to a problem I was unable to solve so far.

The XML has the following structure:

<PhysicalLocation>
<Name>Address</Name>
<Area type="countrycode">
<Value>DE</Value>
</Area>
<Area type="postalcode">
<Value>70173</Value>
</Area>
<Area type="municipality">
<Value>Stuttgart</Value>
</Area>
</PhysicalLocation>

Is there a way to get a column for the value in e.g. area type=„countrycode"?

Any help is very much appreciated!

Thanks!
Björn