giantsfan24 Posted April 5, 2012 Share Posted April 5, 2012 In looking at the code to create the get_shopping_cart/wish_list_contents Stored Procedure, it seams the section for the coffee does not have the phrase "as sku" after the CONCAT. I'm not even sure how you would access that value without the "as sku" command in a statement containing $row[]. Please let me know if this was deliberate or a typo. On further research, a number of stored procedures do this. If you're not setting the CONCAT("C",sc_id) to anything, how would you access it. The same goes for the CONCAT WS right below it. It's not set to "name". Thanks in advance for your explanation and thank you for all your work, turning geek into English:) Link to comment Share on other sites More sharing options...
1cookie Posted April 5, 2012 Share Posted April 5, 2012 In looking at the code to create the get_shopping_cart/wish_list_contents Stored Procedure, it seams the section for the coffee does not have the phrase "as sku" after the CONCAT. Page number, paragraph?? Link to comment Share on other sites More sharing options...
giantsfan24 Posted April 5, 2012 Author Share Posted April 5, 2012 Page number, paragraph?? The specific one I am referring to is on 233-234, but it applies to another procedure defined in chapter 8 as well. Sorry, I thought I included that in my post. Link to comment Share on other sites More sharing options...
1cookie Posted April 6, 2012 Share Posted April 6, 2012 It's a SELECT... UNION...SELECT query (procedure) You only have to define sku 'once' hence the omission. 1 Link to comment Share on other sites More sharing options...
Larry Posted April 6, 2012 Share Posted April 6, 2012 Yes, if you were to run the query directly to see the results, you'd see how this works. Excellent job, 1cookie! Link to comment Share on other sites More sharing options...
Recommended Posts