
Originally Posted by
BFG 9000
Well done though - you got really close !!!
The thing with the entity name is that xml doesn't like the & symbol They're not really valid anywhere & should normally be changed to & - there were a lot of them in the javascript.
TTFN
BFG
Awesome! Thank you! It works GREAT!
I don't understand something though... how does this work? I do not see a query at all for the Product in any way in the new XMLPackage.
In the other packages, there are queries, and in particular, one for Product. Such as:
Code:
<query name="Products" rowElementName="Product" runif="showproduct">
<sql>
<![CDATA[
exec dbo.aspdnsf_ProductInfo @ProductID, @CustomerLevelID, 1, 0, @affiliateID
]]>
</sql>
<queryparam paramname="@ProductID" paramtype="request" requestparamname="ProductID" sqlDataType="int" defvalue="0" validationpattern="^\d{1,10}$" />
<queryparam paramname="@CustomerLevelID" paramtype="runtime" requestparamname="CustomerLevelID" sqlDataType="int" defvalue="0" validationpattern="" />
<queryparam paramname="@affiliateID" paramtype="system" requestparamname="AffiliateID" sqlDataType="int" defvalue="0" validationpattern="" />
</query>
I thought you had to query the information first, before you could use it... No?
Thanks again SO MUCH for your help!