 | |
FOR XML PATH and empty list
microsoft.public.sqlserver.xml microsoft.public.sqlserver.xml
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: FOR XML PATH and empty list -
12-15-2008
, 06:22 AM
|
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/
#12
| |||
| |||
|
|
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/
#13
| |||
| |||
|
|
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/
#14
| |||
| |||
|
|
Miroo wrote: 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? Does 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. |
records returned, I need to get empty list element <LIST />
Finally I found out how to do it, and it is pretty simple:
select ( SELECT [@id]=myid from mytable for xml path ('ITEM'), type )
for XML PATH ('LIST')
--
Regards
Miroo
#15
| |||
| |||
|
|
Miroo wrote: 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? Does 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. |
records returned, I need to get empty list element <LIST />
Finally I found out how to do it, and it is pretty simple:
select ( SELECT [@id]=myid from mytable for xml path ('ITEM'), type )
for XML PATH ('LIST')
--
Regards
Miroo
#16
| |||
| |||
|
|
Miroo wrote: 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? Does 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. |
records returned, I need to get empty list element <LIST />
Finally I found out how to do it, and it is pretty simple:
select ( SELECT [@id]=myid from mytable for xml path ('ITEM'), type )
for XML PATH ('LIST')
--
Regards
Miroo
#17
| |||
| |||
|
|
Miroo wrote: 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? Does 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. |
records returned, I need to get empty list element <LIST />
Finally I found out how to do it, and it is pretty simple:
select ( SELECT [@id]=myid from mytable for xml path ('ITEM'), type )
for XML PATH ('LIST')
--
Regards
Miroo
#18
| |||
| |||
|
|
Miroo wrote: 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? Does 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. |
records returned, I need to get empty list element <LIST />
Finally I found out how to do it, and it is pretty simple:
select ( SELECT [@id]=myid from mytable for xml path ('ITEM'), type )
for XML PATH ('LIST')
--
Regards
Miroo
#19
| |||
| |||
|
|
Miroo wrote: 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? Does 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. |
records returned, I need to get empty list element <LIST />
Finally I found out how to do it, and it is pretty simple:
select ( SELECT [@id]=myid from mytable for xml path ('ITEM'), type )
for XML PATH ('LIST')
--
Regards
Miroo
#20
| |||
| |||
|
|
Miroo wrote: 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? Does 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. |
records returned, I need to get empty list element <LIST />
Finally I found out how to do it, and it is pretty simple:
select ( SELECT [@id]=myid from mytable for xml path ('ITEM'), type )
for XML PATH ('LIST')
--
Regards
Miroo
|
« 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.