Best of Talk (Weekend, 05/15/04 - 05/16/04)

 
May 15, 2004
By Dina Hess

Title: How Do You Concatanate Two Table Fields in CFQUERY with MS Access
Date: 05/15/04      (4 Posts)
Summary: When concatenating strings in an MS Access SQL statement, use '+' not '&.'
 
Title: Strip Multiple Words from String
Date: 05/16/04      (10 Posts)
Summary:

How would you strip duplicate words or phrases from a comma-delimited list? Try this:
<cfset s = "string,this string,string B,that string,my string,this string">
<cfset keywords = "">
<cfloop index="w" list="#s#" delimiters=",">
<cfif not ListFindNoCase(keywords, w)>
<cfset keywords = ListAppend(keywords, w)>
</cfif>
</cfloop>
<cfoutput>
s: #s# <br>
keywords: #keywords#
</cfoutput>
 
Title: New CFEclipse Version Released (Bit Long)
Date: 05/16/04      (1 Post)
Summary: News Flash: The new CFEclipse version (1.1.8) is up on the CFEclipse project site and is ready for download. "CFEclipse is a CFML plug-in for the Eclipse IDE v3.0. Both the IDE and plug-in are free and open source."
 

Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting