Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 4 of 4

Thread: Run SQL Update XML Package

  1. #1
    apastue@kingpar.com is offline Junior Member
    Join Date
    Nov 2009
    Location
    Michigan
    Posts
    20

    Default Run SQL Update XML Package

    I am trying to update the XML package based on the section or department they are in using the Run SQL feature in the back of the aspdnsf. When I run the SQL Below the script will update all the products to this xml package not just the product with the section ID 12. It seems like it is ignoring the cross join.


    UPDATE Product
    SET XmlPackage = 'product.variantsinrightbar-hp.xml.config'
    FROM Product CROSS JOIN
    Product Section
    WHERE (Section.SectionID = '12')
    Thank you,

    Andrew Pastue
    http://www.kingparsuperstore.com

  2. #2
    jsimacek is offline Senior Member
    Join Date
    Dec 2008
    Location
    Phoenix, AZ
    Posts
    373

    Default

    Try it like this:

    UPDATE Product
    SET XmlPackage = 'product.variantsinrightbar-hp.xml.config'
    WHERE ProductID IN (SELECT ProductID FROM ProductSection WHERE SectionID=12)
    Jan Simacek - Compunix, LLC
    AspDotNetStorefront trusted Devnet Partner and Reseller since 2005

    AspDotNetStorefront Mods and Add-Ons at http://www.ecommercecartmods.com/
    - Searching, Filtering and Sorting (like cSearch, Dealer Locator, Price Ranges, Blog)
    - Reports (like Cart Abandonment and Net Sales)
    - Customer Experience (like Question/Answers)
    - Site and Data Management (like Entity Product Mapper, Bulk Updaters, Make/Model/Year filters)

  3. #3
    apastue@kingpar.com is offline Junior Member
    Join Date
    Nov 2009
    Location
    Michigan
    Posts
    20

    Default Thank you! It worked

    Thank you very much! That worked. I appreciate your help!!!
    Thank you,

    Andrew Pastue
    http://www.kingparsuperstore.com

  4. #4
    jsimacek is offline Senior Member
    Join Date
    Dec 2008
    Location
    Phoenix, AZ
    Posts
    373

    Default

    Very welcome!
    Jan Simacek - Compunix, LLC
    AspDotNetStorefront trusted Devnet Partner and Reseller since 2005

    AspDotNetStorefront Mods and Add-Ons at http://www.ecommercecartmods.com/
    - Searching, Filtering and Sorting (like cSearch, Dealer Locator, Price Ranges, Blog)
    - Reports (like Cart Abandonment and Net Sales)
    - Customer Experience (like Question/Answers)
    - Site and Data Management (like Entity Product Mapper, Bulk Updaters, Make/Model/Year filters)