Best of Talk (06/11/04)

 
Jul 03, 2004

by Dina Hess

Title: Character Encoding - CFMX and SQL
Date: 06/11/04      (5 Posts)
Summary: Using international characters stored as ntext or nvarchar data types? Provide Unicode hints for database inserts and updates by prepending an N to the values. Also, be sure to check the "String Format" box in your datasource advanced settings to enable Unicode for use with CFQUERYPARAM.
 
Title: OT: Regular Expressions in JS (or in General) for Dates
Date: 06/11/04      (5 Posts)
Summary: Need to validate a date and check its format? Find two functions in the related thread that will handle this.
Related: Regular Expressions in JS (or in General) for Dates
 
Title: Dumb UDF Quesiton with Local Variables
Date: 06/11/04      (8 Posts)
Summary: Looking for a way to prevent changes to a local variable with the same name as a function variable? Var scope the function variable, keeping in mind these two rules:
  1. "Var scope declarations MUST come before any other lines of code."
  2. "You MUST declare a value for the variable, even if you change it later."
In CFMX, you can create a function with CFSCRIPT or CFFUNCTION. But CFFUNCTION lets you add validation with returnType and makes it easier to use optional arguments. Code examples of both are included.
 
Title: Finding the Current Directory of a Script
Date: 06/11/04      (11 Posts)
Summary: It's always a good idea to check your ColdFusion Reference for built-in functions that will resolve code problems. For example, getCurrentTemplatePath() will get the full path of the current page and getDirectoryFromPath(getCurrentTemplatePath()) will return the current directory.
 

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