BV Commerce Forum
»
BV Commerce Support
»
General Support
»
HOTFIX-SP2-R - Fix for Very Long SKUs and URL rewriting
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
The stored procedures bvc_Product_BySku_s and bvc_Product_BySkuAll_s have a limit of 36 characters while the SKU field is actually 50 characters long. This SQL script will update both procedures to support 50 character SKUs. To Install: 1) Ask your web host or database administrator to run the attached script on your BVC 5 database. File Attachment(s):  HotFix_R.sql (1kb) downloaded 13 time(s).You cannot view/download attachments. Try to login or register.
|
|
|
|
|
|
Rank: Member
Joined: 1/3/2004(UTC)
Posts: 1,497
|
Shouldn't the statement Code:
[color=#0000ff]
DECLARE[/color][color=#000000] @ProductBvin [/color][color=#0000ff]varchar[/color][color=#808080]([/color][color=#000000]36[/color][color=#808080])
[/color]
actually be? Code:
[color=#0000ff]
DECLARE[/color][color=#000000] @ProductBvin [/color][color=#0000ff]varchar[/color][color=#808080]([/color][color=#000000]50[/color][color=#808080])
[/color]
|
|
|
|
|
|
|
Rank: Member
Joined: 11/5/2003(UTC)
Posts: 1,786
|
Yep, I corrected the attached file. Thanks!
|
|
|
|
|
|
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.