Best of Talk (7/1/03)

 
Jul 19, 2003

by Dina Hess

Title: Best Practice for Building a Large Text File?
Date: 07/01/03      10 Posts
Summary: What's the best way to create a very large text file that must be built line by line? If you try to build the file in an array or append it one line at a time, you risk bringing the server down or dramatically slowing performance. For that reason, it's best to use CFFILE to append about 1,000 lines at a time. Sample code is included.
 
Title: Query of Queries Error
Date: 07/01/03      11 Posts
Summary: Heads up! Several developers report an inconsistency between the behavior of Query of Queries in CF5 and CFMX. In essence, there seems to be an issue with a change to column data types.
 
Title: SQL Query Date Filter
Date: 07/01/03      7 Posts
Summary: Since SQL Server looks at the complete timestamp when evaluating dates, use the following syntax to return all transactions for 7/01/2003: 

   select * from transactions
   where date between '07/01/2003 00:00:00.000' 
   and '07/01/2003 23:59:59.999'

 
Title: SQL Oddity
Date: 07/01/03      21 Posts
Summary: Why does 10509 = id work in T-SQL? Shouldn't it be id = 10509? "In T-SQL you can have a constant on either the left or the right." In fact, any of the following are acceptable: 

   id = 10509
   10509 = id
   id = id
   10509 = 10509
This comes in handy when you're building a dynamic WHERE clause. It enables you to use any expression that is true to move past the WHERE condition and on to the dynamic AND conditions.
 

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