[thelist] MS SQL datatype question

[Casey Crookston]

Ah yes.  I was not setting Scale.  Now it's working.
 
 
-----Original Message-----
From: thelist-bounces at lists.evolt.org [mailto:thelist-bounces at lists.evolt.org] On Behalf Of Jeffrey Barke
Sent: Wednesday, May 23, 2007 4:06 PM
To: thelist at lists.evolt.org
Subject: Re: [thelist] MS SQL datatype question

Casey,

It's been a long time since I worked on SQL Server, but the decimal  
field should be correct. Are you sure scale and precision have been  
set correctly? Or is the rounding occurring at the front-end code?

Jeffrey


On May 23, 2007, at 4:52 PM, Casey Crookston wrote:

> If I want to store the value of 1.5, what is the best datatype to  
> use?  This is not currency, it's just 1 ½.  I would have thought it  
> would be "decimal" but that seems to round up.
>
>
>
> Thanks,
>
>
>
> Casey
>
> -- 
>
> * * Please support the community that supports you.  * *
> http://evolt.org/help_support_evolt/
>
> For unsubscribe and other options, including the Tip Harvester
> and archives of thelist go to: http://lists.evolt.org
> Workers of the Web, evolt !

-- 

* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester 
and archives of thelist go to: http://lists.evolt.org 
Workers of the Web, evolt !