RE: sql data type wierdness

2002-03-11 Thread John McCosker
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

RE: sql data type wierdness

2002-03-11 Thread Dylan Bromby
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

Re: sql data type wierdness

2002-03-11 Thread Stephen Moretti
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.

Re: sql data type wierdness

2002-03-11 Thread Jim McAtee
, 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

RE: sql data type wierdness

2002-03-11 Thread John McCosker
!! 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

RE: sql data type wierdness

2002-03-11 Thread John McCosker
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

RE: sql data type wierdness

2002-03-11 Thread Dylan Bromby
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

RE: sql data type wierdness

2002-03-11 Thread John McCosker
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