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: SQL Query update TaxClassID

  1. #1
    joecalardo is offline Member
    Join Date
    May 2011
    Posts
    61

    Default SQL Query update TaxClassID

    Hello, I have my spreadsheet with column a as the productID, and column B as the taxclassid # ...

    I tried this query

    ="UPDATE ProductID SET TaxClassID=" & B2 & " WHERE ProductID=" & A2

    No luck though ?

    anyone know the method for this ? and also might as well ask ...a method to override the template the product is using thru SQL ? thanks!

  2. #2
    BFG 9000 is offline Senior Member
    Join Date
    Oct 2006
    Location
    South UK
    Posts
    882

    Default

    Try this...

    ="UPDATE Product SET TaxClassID="&B2&" WHERE ProductID="&A2&";"


    TTFN

    BFG

  3. #3
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    For your template question, you could extend your Excel formula like this:

    Code:
    ="UPDATE Product SET XMLPackage='your-package-name.xml.config', TaxClassID=" & B2 & " WHERE ProductID=" & A2
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!

  4. #4
    joecalardo is offline Member
    Join Date
    May 2011
    Posts
    61

    Default

    Thank you again ESE! The SQL guru over here... :-)