daviddawn Posted February 28, 2015 Share Posted February 28, 2015 HI All, been stuck on this for some time now, I rearranged my database by replacing the "product_type" and "product_id" columns for a "sku" column and altered the stored procedure to accept the "sku" and "uid" arguments, I also corrected the scripts to send these arguments to the stored procedures respectivley. however rather than a new seperate product being added it just adds another to the quantity with an increment of 1, i can see all the different sku numbers for different products in the url, but not sure why the stored procedure is not accepting this! any help would be appreciated! many thanks :@) Link to comment Share on other sites More sharing options...
daviddawn Posted March 2, 2015 Author Share Posted March 2, 2015 I Figured it out! Don't use an argument name "sku" when passing to a stored procedure, which is the same name as a column "sku" in the database. little mistakes !!! Link to comment Share on other sites More sharing options...
Larry Posted March 2, 2015 Share Posted March 2, 2015 Apologies for not getting to you earlier, but kudos for figuring it out and thanks for sharing your solution! Link to comment Share on other sites More sharing options...
daviddawn Posted March 2, 2015 Author Share Posted March 2, 2015 no problem buddy! i understand you have a lot to do and a lot of people to help. Link to comment Share on other sites More sharing options...
Recommended Posts