Hello,
this is my asp code where I add a amount to the price field
p.Append cm.CreateParameter("@Price",adCurrency,1,2)
cm("@Price") = price
In my stored procedure I have it like this
@Price Money,
the data type of price field in sql is money
but when I see the data in table it looks like this
150.0000
when it should be $150.00
Can someone tell me why its not adding in the currency format into the table
The Money data type stores data in 8 bytes. The 4 decimal places are used for accuracy. You need not worry that it stores it as 150.0000.
jmurrayhead
If you agree, give me rep.
If you like it here...throw us a few bones to help support us.
The money type is used to contain a precise non-integer number , while real and float can only approximate a value. Actual formatting of the output is up to you. After all, if you were doing a application that included gallons of gas, you'd need the extra digits (i.e. 2.199 as of today).
Wolffy
.-- ----- ..-. ..-. -.--
Opinions expressed are my own and do not necessity reflect those of any sane person. Any code provided is intended to be an example and is provided AS IS. Void where prohibited by law. Not valid in California. Your mileage may vary.
Posting Permissions 
LinkBack URL
About LinkBacks
Reply With Quote
Bookmarks