Best of Talk (7/2/03)

 
Jul 19, 2003
by Dina Hess

Title: CFMX SQLException Error
Date: 07/02/03      16 Posts
Summary: CF gurus team up to analyze a SQL Server connection problem that occurred after an upgrade to CFMX. Conclusions? While the error message indicated an excess of ten simultaneous SQL Server connections, the problem was resolved by reconfiguring all datasources to use the ODBC Socket.
 
Title: Correct Way to Match a Record with a List in One Field?
Date: 07/02/03      9 Posts
Summary: If you "must" store a comma-delimited list of integers in a database field, here's the cleanest syntax for finding a match to a form field integer: 

   SELECT EmailAddr, RecipientID
   FROM SupportEmailRecipient 
   WHERE ','+SubjectID+',' LIKE '%,#FORM.SubjectID#,%'
Of course, normalizing the SubjectID column would be a better approach.
 
Title: Ben Forta Now "Blogging"...
Date: 07/02/03      6 Posts
Summary: Want to keep up with all of the ColdFusion-related weblogs? Bookmark these:

MXNA
http://www.markme.com/mxna/index.cfm?category=ColdFusion

Goog
http://www.fullasagoog.com/index.cfm?blogcat=ColdFusionMX
 
Title: CFMX and Netegrity
Date: 07/02/03      5 Posts
Summary: Need to integrate CFMX with Netegrity? Try using the GetHttpRequestData function to return the headers that Siteminder sets. GetPageContext() is another option.
 
Title: SSL with CFHTTP on MX
Date: 07/02/03      5 Posts
Summary: Problems using CFHTTP on an SSL under CFMX? Many developers have solved this problem by upgrading to a 1.4 JRE. To work with a 1.3 JRE, take a look at an entry on Mark Kruger's blogspot.
 
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting