RE: [KCFusion] CF MX and ODBC datasource with decode stmt

2003-10-01 Thread jabrown
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:

RE: [KCFusion] CF MX and ODBC datasource with decode stmt

2003-10-01 Thread Minor, Beth
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

RE: [KCFusion] CF MX and ODBC datasource with decode stmt

2003-10-01 Thread Minor, Beth
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

[KCFusion] ColdFusion contract position - Downtown KC

2003-10-01 Thread Ryan Hartwich
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