Sorry its a float length of 8 dataype,
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 4:22 PM
To: CF-Talk
Subject: sql data type wierdness
greetings,
CF outputs this value from MS SQL SERVER 7.0 as
3.02777801E-2 ,
in
That's pretty vague. What exactly is your question?
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 8:22 AM
To: CF-Talk
Subject: sql data type wierdness
greetings,
CF outputs this value from MS SQL SERVER 7.0 as
3.02777801E-2
Both numbers are the same. Enterprise manager is displaying it cleanly,
where as you probably need a NumberFormat around the cf output of the
variable.
Floating point numbers are generally depicted with the E-x notation as you
never know quite where that decimal point is going to be.
, March 11, 2002 9:25 AM
Subject: RE: sql data type wierdness
Sorry its a float length of 8 dataype,
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 4:22 PM
To: CF-Talk
Subject: sql data type wierdness
greetings,
CF outputs
!!
I only hope you can be as quick to advise as you are to snap.
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 4:28 PM
To: CF-Talk
Subject: RE: sql data type wierdness
That's pretty vague. What exactly is your question?
-Original
Thanks folks, understand better,
J
-Original Message-
From: Jim McAtee [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 4:48 PM
To: CF-Talk
Subject: Re: sql data type wierdness
If you mean the difference in value: Enterprise manager is rounding the
number off slightly, while CF
are all using the same datum as reference ;).
-Original Message-
From: John McCosker [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 8:52 AM
To: CF-Talk
Subject: RE: sql data type wierdness
Sorry for seeming hectic,
some latitudes and longitudes are coming intp SQL server from
Thanks Dylan,
Repectfully,
-Original Message-
From: Dylan Bromby [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 11, 2002 5:02 PM
To: CF-Talk
Subject: RE: sql data type wierdness
I have a fair amount of exp with tens of millions of record SQL DBs with
lat/lon fields. We chose
8 matches
Mail list logo