Best of Talk (6/17/03)

 
Jul 19, 2003

by Dina Hess

Title: Bad News? Re: Tacking a ?jsessionid on the End...
Date: 06/17/03      18 Posts
Summary: How can you prevent CFLOCATION from appending the jsessionid? Replace CFLOCATION with CFHEADER and "set the status code to indicate to the browser that the request should be redirected": 

   <cfheader name="location" value="urlpath"> 
   <cfheader statuscode="302" statustext="Moved Temporarily">
   <cfheader name="Location" value="login.cfm">
Use CFABORT after the redirect to prevent ColdFusion from processing the rest of the page. Note that in CFMX you can add a cookie before a CFLOCATION tag.
 
Title: SQL problem
Date: 06/17/03      13 Posts
Summary: Need to query for maximum values in a group of country records? Take a look at this thread for solutions using the TOP keyword, an inner join on a derived table, and multiple values for the IN predicate (SQL: 1999 standard).
 
Title: Data Getting Truncated on Select
Date: 06/17/03      13 Posts
Summary: Is ColdFusion truncating the display of your SQL Server text data? In ColdFusion Administrator's advanced data source settings, be sure to enable "long text retrieval."
 

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