Re: [DFW CFUG] Strong Data Typing in MX7

Ray Hughes Tue, 21 Mar 2006 09:57:52 -0800

HI David,

I will look for your e-mail, I must have missed it or deleted it byaccident.


I terribly regret previously  missing your e-Mail.

Further, I understand your answer.

However my questions is.

I gave a response to Tony and never viewed any other feedback.

The question is "IS my following response a good answer to Tony's question?

************************************************************
Are 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: "David L. Penton" <[EMAIL PROTECTED]>
To: Dallas/Fort Worth ColdFusion User Group Mailing List<[email protected]>
CC: [EMAIL PROTECTED]
Subject: Re: [DFW CFUG] Strong Data Typing in MX7
Date: Tue, 21 Mar 2006 11:23:15 -0600

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 theprecision and scale of your data in the table. This gives you a clue as towhat it *might* get rendered as on a client. Globalization settings affectthis, 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 yourcode 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 MailingList<[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 MailingList<[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 youdescribed "370.000" .
I believe that if it were defined as varchar then the return value wouldbe "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 MailingList<[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 14550 GU
2 2006 370
The same SQL inside CF returns data in this format (adding the decimalpoint
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 22006
370.000
CF did not use to do that. Is that something new with MX7? Are thereanywork arounds? I now have ".00" showing up all over my site sinceupgrading
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'sFREE! http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
_______________________________________________
Reply to DFWCFUG:  [email protected]
Subscribe/Unsubscribe:http://lists1.safesecureweb.com/mailman/listinfo/listList 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 toget there! http://lifeevents.msn.com/category.aspx?cid=Retirement
_______________________________________________
Reply to DFWCFUG:  [email protected]
Subscribe/Unsubscribe:http://lists1.safesecureweb.com/mailman/listinfo/listList 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/
_________________________________________________________________
Dont 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/listList 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


_________________________________________________________________

Is your PC infected? Get a FREE online computer virus scan from McAfee®Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963



_______________________________________________

Reply to DFWCFUG:[email protected]Subscribe/Unsubscribe:http://lists1.safesecureweb.com/mailman/listinfo/listList Archives:http://www.mail-archive.com/list%40list.dfwcfug.org/http://www.mail-archive.com/list%40dfwcfug.org/DFWCFUG Sponsors:www.HostMySite.comwww.teksystems.com/

Re: [DFW CFUG] Strong Data Typing in MX7

Reply via email to