Modifying XML header generation

EDN Admin

EDN Admin

Well-known member
Joined
Aug 7, 2010
Messages
12,794
Location
In the Machine
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:11px; line-height:13px I am trying to achieve the following below:
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:11px; line-height:13px <img src="http://social.microsoft.com/Forums/getfile/32550/" alt="

<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:11px; line-height:13px <span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:11px; line-height:13px But
Im having the following issues
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:11px; line-height:13px <img src="http://social.microsoft.com/Forums/getfile/32551/" alt="
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:11px; line-height:13px I can show some of the SQL code which im using to generate the header section of the XML file.

<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px WITH XMLNAMESPACES
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px (
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px http://www.w3.org/2001/XMLSchema-instance AS xsi
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px )
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px SELECT (
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px SELECT AMF-XML-Schema.xsd AS @xsi:noNamespaceSchemaLocation,
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <br/>

<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre (SELECT
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre (SELECT ICPN AS EAN
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre FROM tbConfiguration cx1
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre WHERE cx1.ConfigurationId = c.ConfigurationId
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre FOR XML Path(itemIdentifier), TYPE),
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre (SELECT ConfigurationTitle AS Title
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre FROM tbConfiguration cx2
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre WHERE cx2.ConfigurationId = c.ConfigurationId
<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif <span style="font-size:11px; line-height:13px <span style="white-space:pre FOR XML Path(OriginalLanguage), ROOT(title), Type),

<span style="color:#333333; font-family:Segoe UI,Lucida Grande,Verdana,Arial,Helvetica,sans-serif; font-size:11px; line-height:13px Can someone point me in the right direction, Im guessing im using the wrong syntax here.
Thanks
K


View the full article
 
Back
Top