Re: [DFW CFUG] Strong Data Typing in MX7

Tue, 21 Mar 2006 09:23:56 -0800 

Ray,

I replied originally to your message.  Here is the text again:
Both money and smallmoney in SQL Server have a scle of 4. Please check the precision and scale of your data in the table. This gives you a clue as to what it *might* get rendered as on a client. Globalization settings affect this, as does your machine's regional settings.
For the most part, if you want to guarantee that a value (any value - date/time/decimal/etc...) is a specific format always, then provice in your code that exact format. 

Remember:

  visible data format != data storage

 - dave


Ray Hughes wrote:

HI All,

Do I have bad breath?

Regards.



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 Mar 2006 12:34:31 -0600

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/


_________________________________________________________________
Don’t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/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/


--
David L. Penton, Microsoft MVP
JCPenney Application Specialist / Lead
"Mathematics is music for the mind, and Music is Mathematics for the Soul. - J.S. 
Bach"
[EMAIL PROTECTED] (972.431.5796)

Do you have the VBScript Docs or SQL BOL installed? If not, why not?
VBScript Docs: http://www.davidpenton.com/vbscript
SQL BOL: http://www.davidpenton.com/sqlbol

_______________________________________________
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/

Reply via email to