Best of Talk (6/13/03)

 
May 29, 2003

by Dina Hess

Title: UNC and CFDirectory
Date: 06/13/03      5 Posts
Summary: What is the correct CFDIRECTORY syntax for a networked drive? 

   <CFDIRECTORY
      ACTION="LIST"
      DIRECTORY= \\myserver\myfolder\">
Add a trailing backslash to the network share so permissions will propogate properly and make sure ColdFusion is running as a user with permissions to that share.
 
Title: Hyphen in a Variable Name?
Date: 06/13/03      13 Posts
Summary: How would you output the value of a variable with a hyphenated name? If you're using CFMX, you can simply wrap the variable with brackets. Otherwise, try the RenameQueryColumns custom tag to remove the hyphen from the variable name. Another option might be to alias the column in the query.
 
Title: Efficient Solution
Date: 06/13/03      5 Posts
Summary: Looking for an efficient way to create email links only if a person has an email address? Although you could check each record for an empty email string, it's more efficient to let the DBMS do the work. Both solutions are included in this thread.
 
Title: Numbers Too Big
Date: 06/13/03      9 Posts
Summary: Need to determine a country name based on a query of international phone number ranges? The first step is to normalize the phone number ranges using the ITU E.164 format for storing phone numbers. Store country codes in a separate table. A sample query is included in the related thread.
Related: Phone Numbers - Update on Previous Problem
 

Add a Comment
(If you subscribe, any new posts to this thread will be sent to your email address.)
  
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting