For some reason, when reading numeric columns out of the Oracle database,
(at least with coming off the IBM), it does not convert the numeric values
from EPICIC (the native IBM language) to ASCII. You just get funky
characters instead of the values and you can't interpret them. So, to
remedy this, we either avoid using numeric formats in the table or do a
To_Char(column_name) in the SQL to force the data to ASCII.
Dave
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 05, 2000 9:57 AM
Subject: RE: Oracle and Cold Fusion
What is the "to_char problem"?
-----Original Message-----
From: Dave Hannum [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 05, 2000 9:30 AM
To: CF-Talk
Subject: Re: Oracle and Cold Fusion
You are the first others I've heard of with that same To_Char problem. I
thought it just might be a configuration issue on our end, (NT 4.0 SP5 &
IBM) but it appears that we're not the only one now. Does anybody know if
it's a CF issue or an Oracle issue, because when I talked to Allaire and
Oracle, they both just pointed the finger at each other and neither was
interested in addressing the problem.
Dave
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
