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 9 of 9

Thread: 2 of each products displaying on entity.grid.xml.config

  1. 06-03-2010, 12:44 PM #1
    dplsr is offline Member
    Join Date
    Dec 2009
    Posts
    50

    Default 2 of each products displaying on entity.grid.xml.config

    I am getting 2 of each product on entity.grid.xml.config? How do I correct this?
    example
    http://www.lightingsayu.com/c-50-island-lighting.aspx
  2. 06-04-2010, 05:38 AM #2
    storedeveloper is offline Member
    Join Date
    May 2009
    Posts
    77

    Default hi

    have you modified your storeproc ? This is due to storeproc changes.
  3. 06-04-2010, 05:53 AM #3
    dplsr is offline Member
    Join Date
    Dec 2009
    Posts
    50

    Default

    Hi storedeveloper, No, the only stored procedure I have modified is added MSRP to aspdnsf_ProductInfo. Which sp should I look at?
  4. 06-04-2010, 06:11 AM #4
    ASPAlfred is offline Senior Member
    Join Date
    Nov 2007
    Posts
    2,244

    Default

    What version you are on? Do you have multiple category mappings on that particular product?
  5. 06-04-2010, 06:18 AM #5
    dplsr is offline Member
    Join Date
    Dec 2009
    Posts
    50

    Default

    ML 8.0.1.2/8.0.1.2. Yes the products are in 2 categories.
  6. 06-05-2010, 02:27 AM #6
    storedeveloper is offline Member
    Join Date
    May 2009
    Posts
    77

    Default Hi

    please check the storeproc aspdnsf_getproducts which returns all the product with the running category.
  7. 06-05-2010, 05:21 AM #7
    dplsr is offline Member
    Join Date
    Dec 2009
    Posts
    50

    Default

    What should I change on aspdnsf_getproducts. This sp has not been modified since the software was installed.
  8. 06-06-2010, 10:15 PM #8
    storedeveloper is offline Member
    Join Date
    May 2009
    Posts
    77

    Default hi

    I think you have same product in manufacturere and category. you need to modified your storeprocedure. in the aspdnsf_getproducts at very bottom there is a join for the manufacturere. please remove this line and the excute storeproc and then check.

    i think it works. if not then we have to check your xmlpackage and db.

    Thanks
  9. 06-07-2010, 06:45 AM #9
    dplsr is offline Member
    Join Date
    Dec 2009
    Posts
    50

    Default

    Good morning! I commented out
    /*left join dbo.ProductManufacturer pm with (NOLOCK) on p.ProductID = pm.ProductID
    left join dbo.Manufacturer m with (NOLOCK) on pm.ManufacturerID = m.ManufacturerID */

    I get errors
    Msg 4104, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 372
    The multi-part identifier "m.ManufacturerID" could not be bound.
    Msg 4104, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 373
    The multi-part identifier "m.Name" could not be bound.
    Msg 4104, Level 16, State 1, Procedure aspdnsf_GetProducts, Line 374
    The multi-part identifier "m.SEName" could not be bound.