XML EXPLICIT Query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

XML EXPLICIT Query

Author

Topic

OMB
Yak Posting Veteran

88 Posts

Posted - 2002-08-08 : 03:41:51

I have the following query that produces a XML message, all is well except the last element "Details" is a text field. when the message is created it looses it's formating and truncates some text. I suspect it has something to do with the arguments I am specifying for the element. any help would be grately appreciated.



set nocount on 

SELECT 
1 as tag,
NULL as parent,
ISNULL(CompanyName,'')as [BODY!1!CompanyName!XML],
ISNULL(IssueType,'')as [BODY!1!IssueType!XML],
ISNULL(NewIssueClosingDate,' ')as [BODY!1!NewIssueClosingDate!XML],
ISNULL(NewISsueDAteOnOFEX,'')as [BODY!1!NewISsueDAteOnOFEX!XML],
ISNULL(URL,'')as [BODY!1!URL!XML],
ISNULL(Details,'')as [BODY!1!details!element!xml]

FROM vNewISsues (NOLOCK)
WHERE CaplinID = 4
AND (Status IN ( 'PENDING') or DisplayUntildate >= getdate())
and Status <> 'LIVE'
for xml explicit

set nocount off

P.S

Does any one know any good sites or books that give cover XML functionality with SQL server

Thanx in advance

OMB

Edited by - omb on 08/08/2002 03:57:48

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2002-08-08 : 04:08:46

Not entirely sure of the answer to the question but in terms of sites
[url]http://www.sqlxml.org[/url]is the place to go for SQLXML

HTH
Jasper Smith

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources