Values set to zero after SQL INSERT is performed

[ProWeb]

Hi,

Bit of a strange one this.

I have an sql insert happening on a ASP page...
Heres the statement:
update shop.Orders set Shipping = 0,ShipVia = '',SpecialIntructions = '',whopartyfor = '',dateofbirth = '',dateofparty = '',TotalDiscount = 0.00,OrderTotal = 599.99,OrderCreditted = 9744,NetOrderTotal = 599.99,PointsUsed = 0,PointsEarned = 3,000 where OrderID = 9744

I output it to the screen so the values are from real data.

After the insert i check the data in the table and NetOrderTotal and OrderTotal are both 0.00. The fields are both currency fields and this only seems to happen with large numbers like 599.99 rather than 89.99?!

This statement works fine
update ghdirect.Orders set Shipping = 0,ShipVia = '',SpecialIntructions = '',whopartyfor = '',dateofbirth = '',datofparty = '',TotalDiscount = 0.00,OrderTotal = 189.99,OrderCreditted = 9744,NetOrderTotal = 189.99,PointsUsed = 0,PointsEarned = 950 where OrderID = 9744

Any help would be good thanks.

Aran

[ProWeb]

think ive solved it, Comma in the Points field (3,000)!