EDN Admin
Well-known member
Hi there,
I was trying to add the name space to the header in the xml file ,but when i am trying to do this extra xmlns is getting added example:
/header start/
date = 2011/10/11 , xmlns = <span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px "<a title="http://www.w3.org/1999/XSL/Transform http://www.w3.org/1999/XSL/Transform" style="font-weight:inherit; font-style:inherit; font-family:inherit; outline-width:0px; outline-style:initial; outline-color:initial; color:#0066dd; text-decoration:none; list-style-type:none; padding:0px; margin:0px; border:0px none initial http://www.w3.org/ >
,
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px /subheader xmlns=""/
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px elements underthis.......................
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px /subheader end/>
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px /header end />
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px In the above example i want to add only xmlns to the header part ,i want to remove xmlns = " " from the subheader part.
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px Is there any sql query that can be used to do this.I am using sql server 2008 . I am generating the xml file using the
sql query.
View the full article
I was trying to add the name space to the header in the xml file ,but when i am trying to do this extra xmlns is getting added example:
/header start/
date = 2011/10/11 , xmlns = <span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px "<a title="http://www.w3.org/1999/XSL/Transform http://www.w3.org/1999/XSL/Transform" style="font-weight:inherit; font-style:inherit; font-family:inherit; outline-width:0px; outline-style:initial; outline-color:initial; color:#0066dd; text-decoration:none; list-style-type:none; padding:0px; margin:0px; border:0px none initial http://www.w3.org/ >
,
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px /subheader xmlns=""/
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px elements underthis.......................
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px /subheader end/>
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px /header end />
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px In the above example i want to add only xmlns to the header part ,i want to remove xmlns = " " from the subheader part.
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:13px; line-height:16px Is there any sql query that can be used to do this.I am using sql server 2008 . I am generating the xml file using the
sql query.
View the full article