worked on lots of sites where the original developers where not knowledgable
about SQL and they wrote good CF code, but handled EVERYTHING in CF ... not
a good solution. It's like trying to change a tire with a pliers.
-mk
-----Original Message-----
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Friday, September 03, 2004 4:03 AM
To: CF-Talk
Subject: Re: Access alternatives (WAS: Security gurus out there?)
Matt Robertson wrote:
> Jochem wrote:
>>
>> After doing a simple division by 2.20371, your balance doesn't quite
>> balance anymore.
>
> You mean do the division in the sql? Thats something I would never
> do, personally.
Where else can you do it and have control over precision and
rounding? In CF we have no control over the datatype, which means
there is no way we can control precision if there is an int to
float conversion in an unexpected place.
In databases we have exact numeric types of arbitrary scale and
precision that have a behaviour that is exactly specified by the
SQL standard. Except in MySQL.
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
