#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2003
    Posts
    1
    Rep Power
    0

    Question 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. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2003
    Posts
    21
    Rep Power
    0
    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.

IMN logo majestic logo threadwatch logo seochat tools logo