Best of Talk (05/27/04)

 
Jun 02, 2004

by Dina Hess

Title: ColdFusion TechNote Notification: CFMX 6.1: Request timed out waiting...
Date: 05/27/04      (1 Post)
Summary: If you've been seeing timeout errors in your logs for high-volume sites or long-running templates, check out Macromedia's recommendations for increasing the threadWaitTimeout attribute.
 
Title: SQL Help
Date: 05/27/04      (8 Posts)
Summary: Need to group dates of birth by age for a mySQL database? Try this:
SELECT
CASE
WHEN age <= 16 THEN 1
WHEN age BETWEEN 17 AND 25 THEN 2
WHEN age BETWEEN 26 AND 40 THEN 3
ELSE 4
END
AS
[group]
 
Title: MS Access as a Backend Database
Date: 05/27/04      (19 Posts)
Summary: Considering the use of MS Access for your web application? Then this thread is a "must-read." Find Dave Watts' clearly enumerated list of disadvantages, as well as an eye-opening query speed comparison. Conclusion? Access is "simply not designed to be a transactional database for applications that support multiple concurrent users."
 
Title: PL/SQL Stumper
Date: 05/27/04      (22 Posts)
Summary: Need to return the 7 most recent distinct providers from an Oracle table? Use a subquery with GROUP BY and ORDER BY clauses, and then filter the result set by ROWNUM to simulate TOP-n styled SQL.
 
Title: Subject: IDE for ColdFusion MX
Date: 05/27/04      (22 Posts)
Summary: Looking for a development environment like ColdFusion Studio but with CFMX tag upgrades? Homesite+ is available on the same CD as Dreamweaver MX and *is* ColdFusion Studio sans the access violations. Alternative IDEs include CFEclipse, DWMX2004, PrimalScript and the RichPallet/He3 beta, which is slated for release at CFUN-04.
Related: IDE for ColdFusion
 

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