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 to normalize all values into whole numbers. We had some of our own data, data from 3rd parties, and services from still more 3rd parties. It was critical to maintain the data in a consistent format on our end. Since we did a myriad of things with the data, we would've wound up converting the format anyway, so we didn't introduce any real additional work by normalizing the disparate lat/lon formats into one format. Of course, that's assuming the datafeeds you're getting lat/lon values from 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 server agents listening to GSM and GPS satellites, CF is displaying the data on some occaissions which seems to be wrong, e.g. In a vehicle reports page, I'm just outputting that data straight, no manipulation one or two longitude and latitudes now and again appear in this numeric format 3.0277780000000001E-2, not in this exact format but with E-2 on the end, in SQL SERVER through enterprise manager it says its 0.03027778, I am also showing this vehicle on a map, on one occaision the vehicle should have been driving up the M6 from Birmingham, but instead was somewhere in Egypt. I can quite easily catch these rogue longitudes and latitudes from causing errors, I just quite simply wondered, which is showing me true data representation, CF or SQL SERVER, you see the problem is I don't know!! 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 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.0277780000000001E-2 ", in enterprise manager the value looks like this " 0.03027778 " any help would be appreciated, respectfully, J ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
