|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
|
|
#1
October 25th, 2003, 08:12 PM
|
|||
|
|||
currency problem
Hi!
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! Cosmin
|
|
#2
November 14th, 2003, 11:01 AM
|
|||
|
|||
|
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.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > currency problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
