RE: [KCFusion] CF MX and ODBC datasource with decode stmt
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: Hagemeyer, David A. Subject: [KCFusion] CF MX and ODBC datasource with decode stmt We are currently using CF 5 and are in the process of upgrading to CF MX. We use ORACLE databases and ODBC data sources. While testing with CF MX I am finding that our cfqueries that use decode statements in the sql, error out with a SQLSTATE 01S01 message. Has anyone encountered this or have any ideas? Thanks, Beth Minor DB Programmer Analyst University of Missouri Columbia, MO __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CF MX and ODBC datasource with decode stmt
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 decode(type_add,'WAG',monetary_amount,0) as wage_amount, decode(type_add,'BEN',monetary_amount,0) as benefit_amount FROM sysadm.Table_name WHERE emplid = 'kjfdlk' and distrib_line_num = '001' Works on the server via SQL Plus. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:05 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt 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: Hagemeyer, David A. Subject: [KCFusion] CF MX and ODBC datasource with decode stmt We are currently using CF 5 and are in the process of upgrading to CF MX. We use ORACLE databases and ODBC data sources. While testing with CF MX I am finding that our cfqueries that use decode statements in the sql, error out with a SQLSTATE 01S01 message. Has anyone encountered this or have any ideas? Thanks, Beth Minor DB Programmer Analyst University of Missouri Columbia, MO __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] CF MX and ODBC datasource with decode stmt
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 help some at the time. Beth -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:30 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt Beth, You might try using the Oracle driver in the cf admin instead of the odbc socket to see if that solves it. That's what we use for ours. Otherwise, our setup looks pretty much the same. Slight version differences but nothing major. Is there a specific reason you are using ODBC? -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:20 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt 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 decode(type_add,'WAG',monetary_amount,0) as wage_amount, decode(type_add,'BEN',monetary_amount,0) as benefit_amount FROM sysadm.Table_name WHERE emplid = 'kjfdlk' and distrib_line_num = '001' Works on the server via SQL Plus. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 01, 2003 4:05 PM To: [EMAIL PROTECTED] Cc: Hagemeyer, David A. Subject: RE: [KCFusion] CF MX and ODBC datasource with decode stmt 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: Hagemeyer, David A. Subject: [KCFusion] CF MX and ODBC datasource with decode stmt We are currently using CF 5 and are in the process of upgrading to CF MX. We use ORACLE databases and ODBC data sources. While testing with CF MX I am finding that our cfqueries that use decode statements in the sql, error out with a SQLSTATE 01S01 message. Has anyone encountered this or have any ideas? Thanks, Beth Minor DB Programmer Analyst University of Missouri Columbia, MO __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] *** * This message and any attached documents are confidential and* * intended solely for the use of the individual or entity to whom * * they are addressed. If this message and any attached documents * * were received in error, notify [EMAIL PROTECTED] and * * erase all copies of this message and any attached documents.* *** __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/[EMAIL PROTECTED] Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe
