[KCFusion] finding computername using CF 5
We are setting up servers for load balancing and I am trying to figure out a way to display the computername. Found a getenv function on the http://www.cflib.org/udf.cfm?ID=777 website that will do this - but it only works for CF MX and we are using CF 5. Does anyone know how to find the computername using CF 5.0? Thanks, Beth Minor Beth Minor Database Programmer Analyst-Principal University of Missouri System phone (573) 882-9242 [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
RE: [KCFusion] finding computername using CF 5
Thanks for the quick replies - I am looking for the actual network machine name of the server. We will be using a file replication system to keep the code the same between all servers, so I'm not quite sure how to do that and use the suggestion below. Why is using CFREGISTRY bad? Beth Minor -Original Message- From: Greenhagen, Robin [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 11:12 AM To: [EMAIL PROTECTED] Subject: RE: [KCFusion] finding computername using CF 5 You can put a quick custom tag in the CustomTags directory that will set a variable for you like REQUEST.SERVERNAME and then just customize that for each machine. The REALLY dynamic but bad way to do it is to use CFREGISTRY to do it Robin Greenhagen President GSI http://www.gsi-kc.com/ -Original Message- From: Minor, Beth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 19, 2003 11:05 AM To: [EMAIL PROTECTED] Subject: [KCFusion] finding computername using CF 5 We are setting up servers for load balancing and I am trying to figure out a way to display the computername. Found a getenv function on the http://www.cflib.org/udf.cfm?ID=777 website that will do this - but it only works for CF MX and we are using CF 5. Does anyone know how to find the computername using CF 5.0? Thanks, Beth Minor Beth Minor Database Programmer Analyst-Principal University of Missouri System phone (573) 882-9242 [EMAIL PROTECTED] __ The KCFusion.org list and website is hosted by Humankind Systems, Inc. List Archives http://www.mail-archive.com/cf-list@kcfusion.org 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/cf-list@kcfusion.org 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/cf-list@kcfusion.org Questions, Comments or Glowing Praise.. mailto:[EMAIL PROTECTED] To Subscribe mailto:[EMAIL PROTECTED] To Unsubscribe mailto:[EMAIL PROTECTED]
[KCFusion] CF on Netscape and IE
The CF apps I currently work on are written to work with Internet Explorer only. When the apps were written a few years ago and used with Netscape there were a few problems (mostly javascript and cosmetic), so we decided to kick the users out of our apps if they try to access them using Netscape. We didn't have time to get them working on both browsers at the time. Now I'm looking into getting them working on Netscape. The group that maintains our CF server now, has indicated that CF can be used with Netscape or IE, but trying to apply patches for both browsers and getting the apps to work on both will not be possible. I'm just wanting to get some feedback about how others handle maintaining apps for Netscape and IE. Thanks, Beth Beth Minor Database Programmer Analyst-Principal University of Missouri System phone (573) 882-9242 [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
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