Sign Up
Search
Options
search
Chat
Help
News
Log in
Not Logged in
Home
»
Boards
»
Stylus Studio Developer Network
»
Stylus Studio Code Samples & Utilities
»
sql/xml returns invalid results
Topic
Prev Topic
Next Topic
next
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
top
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
Prev Topic
Next Topic
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:
Select Conference
Stylus Studio Feature Requests
Stylus Studio Technical Forum
Website Feedback
XSLT Help and Discussion
XQuery Help and Discussion
Stylus Studio FAQs
Stylus Studio Code Samples & Utilities
Stylus Studio Announcements
go
Log In Options
Username:
Password:
Site Map
|
Privacy Policy
|
Terms of Use
|
Trademarks
Stylus Scoop XML Newsletter:
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.