Best of Talk (Christmas, 12/24/02 - 12/25/02)

 
Feb 24, 2003
by Dina Hess

Title: DateFormat in CFMX
Date: 12/24/02      15 Posts
Summary: JVM 1.4.1 generates a date-related bug. To work around it, convert the date string to a date object, like this: 

   #DateFormat(parseDateTime
      ('Tuesday, 17 December 2002 05:21:09 PM EST'))#
 
Title: How to Do This Without the Subselect?
Date: 12/24/02      21 Posts
Summary: Here's an example of how to convert a query that uses NOT IN with a subquery to a query that uses LEFT JOIN with a NOT NULL predicate. You will also find helpful strategies for building queries and flattening queries containing subqueries.
 
Title: CFMX / JVM
Date: 12/25/02      20 Posts
Summary: Does Macromedia recommend a specific JVM for best performance? While there is no official recommendation, upgrading the IBM JVM 1.3.1, which ships with the CFMX standalone, will definitely boost performance. List respondents report good luck with JRE 1.4.0_02 and JRocket, but warn that there are date issues with 1.4.1.
 

Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting