We use decode on ORACLE quite often and haven't had any problems since
moving to MX. Can you post an example query? What version of ORACLE?
Jeff
-Original Message-
From: Minor, Beth [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 01, 2003 3:52 PM
To: [EMAIL PROTECTED]
Cc:
Jeff,
The Web server Oracle client is 9.2.0.1.0
The CF MX connection is an ODBC socket to a system DSN set up with Microsoft's
ODBC for Oracle running Windows 2003 server.
The Unix Database server is running 8.1.7.3.0
The Code.
SELECT
THanks for the suggestions -
When we first started developing in CF, we used native drivers and had a lot of
problems with response time and server busy messages. The decision was made by a
consultant to use ODBC datasources - so we converted all the applications to use them.
It did seem to
FYI:
A federal employer in downtown KC has a contract position opening up. The
position is for 4-6 months.
If anyone is interested, contact Jennifer Dempsie, [EMAIL PROTECTED],
913-664-0104, 8101 College Blvd. Suite 230, Overland Park, KS 66210.
Ryan
---
Deliverables:
Contractor will be