 | |
FOR XML PATH and empty list
microsoft.public.sqlserver.xml microsoft.public.sqlserver.xml
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
FOR XML PATH and empty list -
12-15-2008
, 02:10 AM
#2
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#3
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#4
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#5
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#6
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#7
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#8
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#9
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
#10
| |||
| |||
|
|
I'm simply listing records from a database into such xml: LIST ITEM id=1" / ITEM id=2" / ... /LIST I was using FOR XML EXPLICIT for that but now I'd like to do it using more friendly FOR XML PATH mode. The problem is that if there is no records in the list it returns empty XML. In FOR XML EXPLICIT mode it returned empty element. LIST / How to achieve it in FOR XML PATH mode? |
FOR XML PATH, ROOT('LIST')
do what you want? If not then you need to tell us more about your
table(s) you want to query.
--
Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.