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]