SSDN - sql/xml returns invalid results

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Steve Trythall

Subject: sql/xml returns invalid results
Author: Steve Trythall
Date: 01 Jul 2005 01:17 PM

I am using sql/xml to retrieve an ID from the equipment table:

select
xmlelement (name device,
XMLATTRIBUTES(e.ID),
) as "devices"
from EQUIPMENT e

when I run it I get these results:

<?xml version="1.0" encoding="UTF-8" ?>
<root>
<row>
<devices><DEVICE ID="18711"></DEVICE></devices>
</row>
</root>

SS treats the contents of the device element as a single piece of text rather than XML. What am I doing wrong?

Thanks

Steve

Ivan Pedruzzi

Subject: sql/xml returns invalid results
Author: Ivan Pedruzzi
Date: 01 Jul 2005 01:46 PM

Steve,

Assuming that the errors in the query are typos, it should be
SELECT XMLELEMENT(name "devices", XMLATTRIBUTES(e.ID)) FROM EQUIPMENT e

It should work just fine. I tried the following against SQLServer

SELECT XMLELEMENT(name "devices", XMLATTRIBUTES(t.emp_id))
FROM pubs.dbo.employee t

resulting in

<?xml version='1.0' encoding='UTF-8'?>
<root>
<devices emp_id='A-C71970F'></devices>
...
</root>

Which Stylus Studio version are you running?

Against which a database?

Hope this helps
Ivan Pedruzzi
Stylus Studio Team

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.