This is the first time that I have used MvOPENVIEW in a module so I am not sure what I am doing wrong. I am trying to look up to see if a product is using a variant price and then output the parts that make up that variant price. The MvWHILE only displays the first value in the database in an infinite loop. It should display three values and then exit but it isn't for some reason.
Code:
<MvOPENVIEW NAME="Merchant" VIEW="PVP" QUERY="{ 'SELECT * FROM s01_ProductVariantPricing WHERE product_id = ' $ l.product:id }"> <MvOPENVIEW NAME="Merchant" VIEW="PV" QUERY="{ 'SELECT * FROM s01_ProductVariantParts WHERE product_id = ' $ PVP.d.product_id }"> <MvWHILE EXPR = "{ (NOT PV.d.EOF) AND (PV.d.product_id EQ PVP.d.product_id) }"> <MvEVAL EXPR="{ 'Part ID: ' $ PV.d.part_id $ ' <br>' }"> </MvWHILE> <MvCLOSEVIEW NAME="Merchant" VIEW="PV"> <MvCLOSEVIEW NAME="Merchant" VIEW="PVP">
Comment