Looking for old forum posts and information? View the old forum archive here ยป
Welcome to Vortx Community Forum, where you can ask questions and receive answers from the staff at Vortx and other members of the community.

If you had a user account on our previous forums website, you will need to register a new account here.

A static copy of our previous forums website is available online for reference. Click here to access the forum archive.

Learn more about...

AspDotNetStorefront
DotFeed

XMLPackages postprocessing not working

At the bottom of script.bodyclose.xml.config we have:

 

	</PackageTransform>
  <PostProcessing>
    <queryafter>
      <sql>
            UPDATE Customer SET ExtensionData=@agent WHERE CustomerID=@CustID AND @CustID > 0;
      </sql>
      <queryparam paramname="@CustID" paramtype="xpath" requestparamname="/root/System/CustomerID" sqlDataType="int" defvalue="0" validationpattern="" />
      <queryparam paramname="@agent" paramtype="xpath" requestparamname="/root/ServerVariables/HTTP_USER_AGENT" sqlDataType="varchar" defvalue="" validationpattern="" />
    </queryafter>
  </PostProcessing>
</package>

This worked in v9.5, but in v10 we get 

ExecuteNonQuery: CommandText property has not been initialized

And the problem seems to be in core >xmlpackages.cs line 1214 where "var sql = node.sql as string;" returns null rather than the actual sql from the package.

Does this work correctly for anyone else?

asked Nov 17, 2016 in MultiStore by esedirect (385 points)

Please log in or register to answer this question.

...