I have run across an interesting error in the Attribute update stored procedure. It is moving a field around for some reason.

 

In the stored procedure DSC_Product_Update_Product_Attribute I put a:

 

 

 

Here is the snippet that is being parsed:

 

CR250M 75-77OVER SIZE 1.5mm (#338M07150);117.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 2.0mm (#338M07200);117.95;NULL;NULL;NULL;MT/MR250 1975-77 STANDARD (#338M07000);114.95;NULL;NULL;NULL;

 

For some reason you can see on line 32 the price becomes the first value instead of the second value. This is causing the error that I am seeing because it want to push a string value into the money field. I have no idea why this is happening. Any ideas?

 

27 CR250M 75-77OVER SIZE 1.5mm (#338M07150)
28 117.95
29 NULL
30 NULL
31 NULL
32 117.95
33 CR250M 75-77 OVER SIZE 2.0mm (#338M07200)
34 NULL
35 NULL
36 NULL
37 MT/MR250 1975-77 STANDARD (#338M07000)
38 114.95
39 NULL
40 NULL
41 NULL
 

I don't think I can reproduce your issue here. When I ran the following query, I got the correct result.

 

SELECT dbo.DSC_Escape(Value, N'\') AS fieldValue
FROM DSC_Parse_Values('CR250M 75-77OVER SIZE 1.5mm (#338M07150);117.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 2.0mm (#338M07200);117.95;NULL;NULL;NULL;MT/MR250 1975-77 STANDARD (#338M07000);114.95;NULL;NULL;NULL;', ';')

 

 

CR250M 75-77OVER SIZE 1.5mm (#338M07150)
117.95
NULL
NULL
NULL
CR250M 75-77 OVER SIZE 2.0mm (#338M07200)
117.95
NULL
NULL
NULL
MT/MR250 1975-77 STANDARD (#338M07000)
114.95
NULL
NULL
NULL
 

You guys are probably figuring out what my business is.  I agree that I don't get an error with this:

SELECT dbo.DSC_Escape(Value, N'\') AS fieldValue
FROM DSC_Parse_Values('114;CR250M 73-74 STANDARD (#337M07000);114.95;NULL;NULL;NULL;CR250M 73-74 1.0mm (#337M07100);114.95;NULL;NULL;NULL;CR250M 75-77 STANDARD (#338M07000);114.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 0.5mm (#338M07050);114.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 1.0mm (#338M07100);114.95;NULL;NULL;NULL;CR250M 75-77OVER SIZE 1.5mm (#338M07150);117.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 2.0mm (#338M07200);117.95;NULL;NULL;NULL;MT/MR250 1975-77 STANDARD (#338M07000);114.95;NULL;NULL;NULL;MT/MR250 1975-77 SIZE 0.5mm (#338M07050);114.95;NULL;NULL;NULL;MT/MR250 1975-77 OVER SIZE 1.0mm (#338M07100);114.95;NULL;NULL;NULL;MT/MR250 1975-77 OVER SIZE 1.5mm (#338M07150);117.95;NULL;NULL;NULL;MT/MR250 1975-77 OVER SIZE 2.0mm (#338M07200);117.95;NULL;NULL;NULL;CR250R 78-80 STANDARD (#431M07000);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 0.25mm (#431M07025);110.95;NULL;NULL;NULL;CR250R 78-80 SIZE 0.5mm (#431M07050);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 0.75mm (#431M07075);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 1.0mm (#431M07100);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 1.25 (#431M07125);124.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 1.5mm (#431M07150);124.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 2.0mm (#431M07200);124.95;NULL;NULL;NULL;CR250R 81-83 STANDARD (#466M06600);108.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 0.5mm (#466M06650);108.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 1.0mm (#466M06700);108.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 1.5mm (#466M06750);116.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 2.0mm (#466M06800);116.95;NULL;NULL;NULL;CR250R 84-85 STANDARD (#526M06600);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 0.25mm (#526M06625);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 0.5mm (#526M06650);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 0.75mm (#526M06675);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 1.0mm (#526M06700);110.95;NULL;NULL;NULL;CR250R 84-85OVER SIZE 1.25 (#526M06725);124.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 1.5mm (#526M06750);124.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 2.0mm (#526M06800);124.95;NULL;NULL;NULL;CR250R 86-89 STANDARD (#614M06640);108.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 0.6mm mm (#614M06700);108.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 1.1mm mm (#614M06750);124.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 1.6mm mm (#614M06800);124.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 2.1mm (#614M06850);124.95;NULL;NULL;NULL;CR250R 90-91 STANDARD (#614M06640);108.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 0.6mm mm (#614M06700);108.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 1.1mm mm (#614M06750);124.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 1.6mm mm (#614M06800);124.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 2.1mm (#614M06850);124.95;NULL;NULL;NULL;CR250R 92-96 STANDARD (#614M06640);108.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 0.6mm mm (#614M06700);108.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 1.1mm mm (#614M06750);124.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 1.6mm mm (#614M06800);124.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 2.1mm (#614M06850);124.95;NULL;NULL;NULL;CR250R 97-01 STANDARD (#702M06640);107.95;NULL;NULL;NULL;CR250R 97-01 OVER SIZE 0.6mm (#702M06700);107.95;NULL;NULL;NULL;CR250R 97-01 OVER SIZE 1.1mm (#702M06750);107.95;NULL;NULL;NULL;CR250R 97-01 OVER SIZE 1.6mm (#702M06800);114.95;NULL;NULL;NULL;CR250R 02-04 STANDARD (#801M06640);105.95;NULL;NULL;NULL;CR250R 02-04 OVER SIZE 2.1mm (#0910-0201);116.95;NULL;NULL;NULL;CR250R 02-04 Racer Choice Piston STANDARD (#0910-0736);124.95;NULL;NULL;NULL;CR250R 05-07 STANDARD (#0910-0737);124.95;NULL;NULL;NULL', ';')
 

 

I am still getting an error from this:

 

exec DSC_Product_Update @ProductId=65,@ProductName=N'Wiseco Pro Light Piston Kit - CR250',@SKU=N'65',@ShortDescription=N'Wiseco piston kits include rings,circlips and piston pin. Don''t forget your gaskets and a new Wiseco top end bearing when rebiulding. Some models require cylinder plating when using oversize Wiseco pistons. ',@Quantity=NULL,@Price=$89.9900,@RetailPrice=NULL,@salePrice=NULL,@Cost=NULL,@ManufacturerId=1,@ManufacturerSKU=NULL,@StatusId=1,@productTypeId=1,

@ShipTypeId=1,@ShipEstimateId=1,@TaxTypeId=1,@Weight=NULL,@WeightMeasureId=NULL,@Length=NULL,@Height=NULL,@Width=NULL,

@DimensionMeasureId=NULL,@SortOrder=0,@timeCreated='2009-01-06 00:00:00',@showIfOutofStock=NULL,@categoriesValues=N'2;0;0',@DefaultImageId=63,@ImageIds='63',@ImageTitles=N'NULL',@DescriptorTitleValues=N'',

@DescriptorDescriptionValues='',@IsBulletedListValues='',@AttributeValues=N'114;CR250M 73-74 STANDARD (#337M07000);114.95;NULL;NULL;NULL;

CR250M 73-74 1.0mm (#337M07100);114.95;NULL;NULL;NULL;CR250M 75-77 STANDARD (#338M07000);114.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 0.5mm (#338M07050);114.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 1.0mm (#338M07100);114.95;NULL;NULL;NULL;CR250M 75-77OVER SIZE 1.5mm (#338M07150);117.95;NULL;NULL;NULL;CR250M 75-77 OVER SIZE 2.0mm (#338M07200);117.95;NULL;NULL;NULL;MT/MR250 1975-77 STANDARD (#338M07000);114.95;NULL;NULL;NULL;MT/MR250 1975-77 SIZE 0.5mm (#338M07050);114.95;NULL;NULL;NULL;MT/MR250 1975-77 OVER SIZE 1.0mm (#338M07100);114.95;NULL;NULL;NULL;MT/MR250 1975-77 OVER SIZE 1.5mm (#338M07150);117.95;NULL;NULL;NULL;MT/MR250 1975-77 OVER SIZE 2.0mm (#338M07200);117.95;NULL;NULL;NULL;CR250R 78-80 STANDARD (#431M07000);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 0.25mm (#431M07025);110.95;NULL;NULL;NULL;CR250R 78-80 SIZE 0.5mm (#431M07050);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 0.75mm (#431M07075);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 1.0mm (#431M07100);110.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 1.25 (#431M07125);124.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 1.5mm (#431M07150);124.95;NULL;NULL;NULL;CR250R 78-80 OVER SIZE 2.0mm (#431M07200);124.95;NULL;NULL;NULL;CR250R 81-83 STANDARD (#466M06600);108.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 0.5mm (#466M06650);108.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 1.0mm (#466M06700);108.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 1.5mm (#466M06750);116.95;NULL;NULL;NULL;CR250R 81-83 OVER SIZE 2.0mm (#466M06800);116.95;NULL;NULL;NULL;CR250R 84-85 STANDARD (#526M06600);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 0.25mm (#526M06625);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 0.5mm (#526M06650);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 0.75mm (#526M06675);110.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 1.0mm (#526M06700);110.95;NULL;NULL;NULL;CR250R 84-85OVER SIZE 1.25 (#526M06725);124.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 1.5mm (#526M06750);124.95;NULL;NULL;NULL;CR250R 84-85 OVER SIZE 2.0mm (#526M06800);124.95;NULL;NULL;NULL;CR250R 86-89 STANDARD (#614M06640);108.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 0.6mm mm (#614M06700);108.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 1.1mm mm (#614M06750);124.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 1.6mm mm (#614M06800);124.95;NULL;NULL;NULL;CR250R 86-89 OVER SIZE 2.1mm (#614M06850);124.95;NULL;NULL;NULL;CR250R 90-91 STANDARD (#614M06640);108.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 0.6mm mm (#614M06700);108.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 1.1mm mm (#614M06750);124.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 1.6mm mm (#614M06800);124.95;NULL;NULL;NULL;CR250R 90-91 OVER SIZE 2.1mm (#614M06850);124.95;NULL;NULL;NULL;CR250R 92-96 STANDARD (#614M06640);108.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 0.6mm mm (#614M06700);108.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 1.1mm mm (#614M06750);124.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 1.6mm mm (#614M06800);124.95;NULL;NULL;NULL;CR250R 92-96 OVER SIZE 2.1mm (#614M06850);124.95;NULL;NULL;NULL;CR250R 97-01 STANDARD (#702M06640);107.95;NULL;NULL;NULL;CR250R 97-01 OVER SIZE 0.6mm (#702M06700);107.95;NULL;NULL;NULL;CR250R 97-01 OVER SIZE 1.1mm (#702M06750);107.95;NULL;NULL;NULL;CR250R 97-01 OVER SIZE 1.6mm (#702M06800);114.95;NULL;NULL;NULL;CR250R 02-04 STANDARD (#801M06640);105.95;NULL;NULL;NULL;CR250R 02-04 OVER SIZE 2.1mm (#0910-0201);116.95;NULL;NULL;NULL;CR250R 02-04 Racer Choice Piston STANDARD (#0910-0736);124.95;NULL;NULL;NULL;CR250R 05-07 STANDARD (#0910-0737);124.95;NULL;NULL;NULL',@billingCycleId=1,@recurringCount=0,@crossSellProductIds='',@productDownloadValues=N'',@Title=N'',@Keywords=N'',

@ExtraHeadData=N'',@CustomFields=NULL