Best of Talk (7/8/03)

 
Jul 19, 2003

by Dina Hess

Title: I Know You Can Do This...But I Always Forget How...
Date: 07/08/03      6 Posts
Summary: How would you retrieve the ID value of a record that was just inserted? SQL Server users can try this: 

   <cfquery name="insertStuff">
      SET NOCOUNT ON
      INSERT xxxx
      VALUES xxxxx
      SELECT ItemIJustInserted=@@IDENTITY

      SET NOCOUNT OFF      
   </cfquery>
 
Title: Search Engine Optimization
Date: 07/08/03      6 Posts
Summary: Need advice about how to get a top search engine ranking? Here are several tips, like the addition of keywords in the TITLE and H1 tags. Also discussed...IIS settings necessary to support search engine safe (SES) URLs formatted as foo.cfm/parm/value.
Related: IIS and Making SES URLs Work [1]
IIS and Making SES URLs Work [2]
 
Title: Caching CFC Objects in the Application Scope
Date: 07/08/03      25 Posts
Summary: While it may boost performance a bit, it's probably a good idea to hold off caching your CFCs in the application scope until a random bug is fixed. The bug, which reportedly "forgets" methods and fails to recognize a valid query recordset, only occurs if a CFC is cached into the application scope.
 
Title: GetPageContext() Function...CFINCLUDE from a CFSCRIPT?
Date: 07/08/03      10 Posts
Summary: Looking for a way to include a file from within a CFSCRIPT block? Try writing a UDF similar to this: 

   <cffunction name="include">
      <cfargument name="template">
      <cfinclude template="#template#">
   </cffunction>
This thread also includes a definition of GetPageContext() as well as resources for information about how it can be used.
 
Title: CrystalTech Says ALL Variables Must Be Locked
Date: 07/08/03      59 Posts
Summary: Locking is only necessary for shared memory variables in the server, application, and session scopes. However, since CF applications all run in the same instance, if your site is running on a shared host, you may see memory corruption problems caused by unlocked memory variables on another CF site — even if your own site uses no memory variables at all!
 

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