October 25th, 2003, 09:12 PM
I'm trying to build a shop using an MS SQL database, but I have a little problem.
I have all the prices in the databases as money type. (ex: 234,45). When I display the price list into my asp pages then I receive the number into this form: 234.45
The problem is when I try to insert this number again into another table (tblOrders). I can't do that anymore because the number has the form : 234.45 and instead of 234,45
Does anyone please help me on this?
Thanks a lot!
November 14th, 2003, 12:01 PM
i'm sure it is something related to the datatype for the asp page but an easy fix would be to run a replace
replace (moneyColumn, '.', ',')
before inserting the data back into the other table.