HI All,
I never read anything further about this issue.
However I could be blind and deaf as well as being ugly.
Having said that.
Does anyone else have any thoughts on Tony's question.
I would like to know for myself the correct answer.
Regards
Ray Hughes
From: "Ray Hughes" <[EMAIL PROTECTED]>
Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing
List<[email protected]>
To: [email protected]
Subject: RE: [DFW CFUG] Strong Data Typing in MX7
Date: Thu, 16 Feb 2006 12:11:32 -0600
Hi Tony,
I am not an expert by any means. My thought is that
the fields in question are defined as datatype "Money" in sql.
In sql I believe when it is defined as Money it is returned as you
described "370.000" .
I believe that if it were defined as varchar then the return value would be
"370".
Now again I am not any type of expert.
Regards
Ray
From: Tony Gray <[EMAIL PROTECTED]>
Reply-To: Dallas/Fort Worth ColdFusion User Group Mailing
List<[email protected]>
To: [email protected]
Subject: [DFW CFUG] Strong Data Typing in MX7
Date: Thu, 16 Feb 2006 11:28:55 -0600
Has anyone noticed this issue in CFMX7?
When quering an Oracle table directly with TOAD results are return like
this.
query - Rows: 1 INVTY_FCST LKM_MILL LKM_MONTH LKM_YEAR SALES_FCST 1
4550 GU
2 2006 370
The same SQL inside CF returns data in this format (adding the decimal
point
and the zeros as the fields are defined in the DB)
INVTY_FCST LKM_MILL LKM_MONTH LKM_YEAR SALES_FCST 1 4550.000 GU 2
2006
370.000
CF did not use to do that. Is that something new with MX7? Are there any
work arounds? I now have ".00" showing up all over my site since upgrading
to CFMX7 recently.
--
Tony Gray
901-419-1775 (w)
901-412-4641 (c)
662-796-1928 (h)
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
_________________________________________________________________
Express yourself instantly with MSN Messenger! Download today - it's FREE!
http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________
Reply to DFWCFUG: [email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
_________________________________________________________________
On the road to retirement? Check out MSN Life Events for advice on how to
get there! http://lifeevents.msn.com/category.aspx?cid=Retirement
_______________________________________________
Reply to DFWCFUG:
[email protected]
Subscribe/Unsubscribe:
http://lists1.safesecureweb.com/mailman/listinfo/list
List Archives:
http://www.mail-archive.com/list%40list.dfwcfug.org/
http://www.mail-archive.com/list%40dfwcfug.org/
DFWCFUG Sponsors:
www.HostMySite.com
www.teksystems.com/
