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 ______________________________________________________________________ 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=coldfusiona 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
