Unwanted Rounding

[Jeff]

I have a decimal datatype set to precision 5 and scale 2. When I try to
insert a new record via ASP using a stored procedure, my numbers are rounded
with no decimals (e.g., 2.2 becomes 2, 2.6 becomes 3, etc.). How can I make
sure the values being entered on my web page are inserted as they are
entered and not rounded? Thank you.

[Jeff]

I have solved this one. I failed to specify the precision and scale in the
stored procedure. Once I did that, my decimals are being stored as I
needed.

"Jeff" <guarna@aol.com> wrote in message
news:uMidncniUf9ggH_dRVn-gQ@lmi.net...

> I have a decimal datatype set to precision 5 and scale 2. When I try to
> insert a new record via ASP using a stored procedure, my numbers are

rounded

> with no decimals (e.g., 2.2 becomes 2, 2.6 becomes 3, etc.). How can I

make

> sure the values being entered on my web page are inserted as they are
> entered and not rounded? Thank you.
>
>