It's set to auto.
After hours of stumbling around try'n sql functions and CF formatting I
finally tried the left function in the SELECT statement.
cfquery name=CourseDetail datasource=OITracker dbtype=OLEDB
SELECT CourseName, CourseDate, LEFT(CourseHours, 6) As CourseHours
FROM Course
WHERE Course.CourseID = #URL.CourseID#
/cfquery
For what ever reason this works and pulls in the decimals as I intended them
to be.
So this will serve as a work around for me, but I still don't understand
what's going on.
Thanks
-Original Message-
From: Janine Jakim [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 9:35 AM
To: CF-Talk
Subject: RE: Trouble with Access and Single Numbers
Do you have the decimal places set to something other than Auto?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 16, 2002 9:41 AM
To: CF-Talk
Subject: Trouble with Access and Single Numbers
I'm having some trouble with pulling some values out of Access. The field is
defined as a number with a field size as single. The problem is CF is
retrieving some decimal values all funny.
2.6 is retrieved as 2.599
1.7 is 1.7
1.9 is 1.9
2.9 is 2.901
9.99 is 9.988
Crazy stuff. They all look fine and as they with in Access but when I
retrieve them with a straight Select in CF funny things happen. I can only
guess that it something to do with single precision thing, but what to do.
Any help
Thanks in advance
Doug Kronenberger
OI National Training and Education Office
Department of Veterans Affairs
440-526-3030 x7776
[EMAIL PROTECTED]
__
Signup for the Fusion Authority news alert and keep up with the latest news in
ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
