Best of Talk (5/22/03)

 
May 29, 2003
by Dina Hess

Title: OT: SQL Help
Date: 05/22/03      3 Posts
Summary: How can you filter records in the right table of a LEFT OUTER JOIN without affecting the records in the left table? Remove the "filter" from your WHERE statement and add it to your join condition, as illustrated in the following code where the "filter" is "s.path=1." 

   SELECT c.categoryID, s.situation
   FROM tbl_categories c LEFT JOIN tbl_situations s 
   ON (c.CategoryID = s.CategoryID AND s.path = 1) 
   ORDER BY c.categoryID, SituationID
Related: SQL Help
 
Title: CFQUERYPARAM Question
Date: 05/22/03      28 Posts
Summary: In this excellent thread, SQL gurus debate whether or not it is best to use CFQUERYPARAM to pass literal values into a SQL string. The point of contention seems to be whether or not the DBMS's execution plan is optimized by doing so.
 
Title: RegEx Help
Date: 05/22/03      6 Posts
Summary: Here's a regular expression that will "find any character (including spaces) other than the following characters: A-Z, a-z, 0-9, period, and underscore":

   [^A-Za-z0-9._]
 
Title: Double Quotes Kill My "Edit" Form...
Date: 05/22/03      11 Posts
Summary: Are double quotes breaking the display of your strings? Apply the HTMLEditFormat() function to convert them to their HTML name entity equivalent (").
 
Title: CFLOGOUT Bug?
Date: 05/22/03      6 Posts
Summary: If you are using CFHEADER style directives and have logged out of an application with CFLOGOUT, what would enable you to re-enter, without entering a username and password, by simply clicking the browser's back and refresh buttons? Since "CFLOGIN and roles-based security have nothing to do with sessions," you may have to destroy any session variables or cookies used to track user logins when you log out.
 
Title: Coding Guidelines Part 2
Date: 05/22/03      9 Posts
Summary: A CF guru recommends using structKeyExists(variables,"x") rather than isDefined("x") not only because it's much faster but also because it's more accurate.
Related: Structs in CFMX- Java
 
Title: CFMX and Locking
Date: 05/22/03      9 Posts
Summary: Take a look at a Macromedia TechNote to get the lowdown on CFMX race conditions and locking best practices. Keep in mind, though, that in situations where no race condition exists, such as when you are using application-scoped variables as pseudo-constants, it isn't necessary to lock the code in CFMX.
 
Title: Yet Another CFC Question
Date: 05/22/03      4 Posts
Summary: Is there any way to consolidate CFC "get" functions? Yes. You can make the query's WHERE clause dynamic by adding "WHERE 1=1" with multiple conditional AND filters. Alternately, you could use key=value pairs with CFSWITCH where the key represents a DB field. Code and pseudo-code examples are included.
 
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting