Home Search Tags Members

Home » Kartris ASP.NET Ecommerce Software » Kartris technical issues » Error in Stored Procedure spKartrisProducts_GetTopList

Error in Stored Procedure spKartrisProducts_GetTopList

Posted By Valerio Thu 4 Sep 2014
Add to Favorites1

Error in Stored Procedure spKartrisProducts_GetTopList

Topic View Topic View Topic Options Topic Options
Author Message
Valerio
Posted Thu 4 Sep 2014
Supreme Being

Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)

Group: Forum Members
Last Active: Tue 31 May 2016
Posts: 10, Visits: 42
Hi,i've an error with that store procedure. I've a catalog of 20.000 products and if I make an order for a product with an ID greater than 255, I get an error from store procedures spKartrisProducts_GetTopList:
"overflow error for data type tinyint, value" and the product id.
How can I fix?
thanks a lot of collaboration.
Post Information
Valerio Marked As Answer
Posted Thu 4 Sep 2014
Supreme Being

Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)Supreme Being - (6,068 reputation)

Group: Forum Members
Last Active: Tue 31 May 2016
Posts: 10, Visits: 42
Solved!If anyone is interested,
i've changed @P_ID and @LANG_ID to int in fnKartrisProducts_GetName and line 20 in spKartrisProducts_GetTopList to
SELECT TOP (@Limit) vKartrisCategoryProductsVersionsLink.P_ID, [dbo].[fnKartrisProducts_GetName](vKartrisCategoryProductsVersionsLink.P_ID, @LANG_ID) AS P_Name
Post Information

Similar Topics

Expand / Collapse

Reading This Topic

Expand / Collapse

Back To Top

Powered By InstantForum.NET 2012-1 © 2024
Execution: 0.078. 8 queries. Compression Enabled.