CFLib.org – Common Function Library Project

Description:
Adds a "FullPath" column to provided directory query (from <cfdirectory action="LIST">). Handy for keeping track of what files were from where when combining directory queries from multiple directories.

Return Values:
query

Example:

<cfset dir = expandPath("./")>

<cfdirectory action="list" directory="#dir#" name="getFiles" filter="*.txt">
ORIGINAL QUERY:<br />
<cfdump var="#getFiles#">
<br /><br />
QUERY WITH NEW FullPath COLUMN:<br />
<cfset addPathsToDirectoryQuery (getFiles, dir)>
<cfdump var="#getFiles#">

Parameters:

Full UDF Source:

/**
 * Adds a "FullPath" column to provided directory query.
 * 
 * @param theQuery      The query returned from CFDIRECTORY (Required)
 * @param basePath      String containing the path to the directory used in the CFDIRECTORY call (Optional)
 * @return query 
 * @author Shawn Seley (shawnse@aol.com) 
 * @version 1, July 9, 2003 
 */
function addPathsToDirectoryQuery(theQuery, basePath) {
    var row = 0;
    var new_col_array = arrayNew(1);

    if (listFindNoCase(theQuery.columnList, "FullPath")) {
        for(row=1; row LTE theQuery.recordCount; row=row+1) {
            querySetCell(theQuery, "FullPath", basePath & theQuery.name[row], row);
        }
    } else {
        for(row=1; row LTE theQuery.recordCount; row=row+1) {
            new_col_array[row] = basePath & theQuery.name[row];
        }
        queryAddColumn(theQuery, "FullPath", new_col_array);
    }

    return theQuery;
}