Best of Talk (05/06/04)

 
May 15, 2004
By Dina Hess

Title: Problem Only Showing Swatches if List Contains a Swatch Name
Date: 05/06/04      (5 Posts)
Summary: Given a list of color codes, how would you match to filenames with corresponding color swatches?
<cfset swatch_files = "1.jpg,130.jpg,130A.jpg,130E.jpg,2.jpg,
23.jpg,3.jpg,30.jpg"> <cfset color_codes = "2,23,23E,30,130,130A,130E">
<cfloop list="#color_codes#" index="color">
<cfif listFind(swatch_files,color & ".jpg")>
<cfoutput>#color# matches #color#.jpg</cfoutput>
</cfif>
</cfloop>
Related: Problem Only Showing Swatches... SOLVED
 
Title: Add a Column in Oracle
Date: 05/06/04      (15 Posts)
Summary: Add a column to an Oracle table like this:
ALTER TABLE "the_table" ADD "new_column" varchar2(100)
Simulate SQL Server's TOP keyword to get the three most current dates by placing the ORDER BY in a subquery and doing your SELECT...WHERE ROWNUM from that:
SELECT column1, column2
FROM (
SELECT column1, column2
FROM the_table
WHERE dateAdded > sysdate - 7
ORDER BY dateAdded DESC
)
WHERE rownum <= 3
 
Title: RESOLVED - FYI : Oracle 9i and CFQUERYPARAM Problems
Date: 05/06/04      (11 Posts)
Summary: Here's a "heads up" that refutes the paradigm to "always use CFQUERYPARAM." One developer discovered that in an ad hoc report application module connecting to an Oracle 9i data source use of CFQUERYPARAM actually slowed performance because it interfered with Oracle's Optimizer.
 
Privacy | FAQ | Site Map | About | Guidelines | Contact | Advertising | What is ColdFusion?
House of Fusion | ColdFusion Jobs | Blog of Fusion | AHP Hosting