Thread: ExtensionData as XML in v9.0.1.3

We used the following query in v8.x to retrieve ExtensionData as properly formatted XML nodes. The same query bombs in v9.x. Is there something I should change? Thanks in advance.

Code:

<query name="Extensions" rowElementName="Product" retType="xml">
        <sql>
            <![CDATA[
                SELECT Product.ProductID, 
                CONVERT(xml, ExtensionData) as ExtensionData
                FROM Product
                WHERE Product.ProductID = @ProductID
                FOR xml path('Product')
            ]]>
        </sql>
        <queryparam paramname="@ProductID" paramtype="request" requestparamname="ProductID" sqlDataType="int" defvalue="0" validationpattern="^\d{1,10}$" />
    </query>

Thanks for your help.

Can you post the stack trace?

Thanks Alfred.

Code:

Page URL:/p-16-product-name.aspx 
Source:.Net SqlClient Data Provider 
Message:XML parsing: line 1, character 44, well formed check: undeclared entity 
Stack Trace: 
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) 
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) 
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) 
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) 
at System.Data.SqlClient.SqlDataReader.HasMoreRows() 
at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) 
at System.Data.SqlClient.SqlDataReader.Read() 
at AspDotNetStorefrontCore.XmlPackage2.GetSqlData(String OnlyRunNamedQuery) in C:\AspDotNetStorefront\Fortress\DP_Products\WebReleases\AspDotNetStorefrontML\Ashland\ASPDNSFCore\XmlPackage2.cs:line 1324 
at AspDotNetStorefrontCore.XmlPackage2..ctor(String PackageName, Customer cust, Int32 SkinID, String UserQuery, String AdditionalRuntimeParms, String OnlyRunNamedQuery, Boolean UseExtensions) in C:\AspDotNetStorefront\Fortress\DP_Products\WebReleases\AspDotNetStorefrontML\Ashland\ASPDNSFCore\XmlPackage2.cs:line 367 
at AspDotNetStorefront.showproduct.Page_Load(Object sender, EventArgs e) in c:\store9013\Web\showproduct.aspx.cs:line 540 
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) 
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) 
at System.Web.UI.Control.OnLoad(EventArgs e) 
at System.Web.UI.Control.LoadRecursive() 
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Alfred,

It was my fault. I did not declare an XML entity which I had done in V8.

Thanks.

Thanks for the update.

Originally Posted by dayhawk

It was my fault. I did not declare an XML entity which I had done in V8.

What is involved in declaring an XML entity? How is it done?