CFLib.org – Common Function Library Project

Description:
Creating large queries with queryNew() and specifying data types can be frustrating. The long comma separated lists of fields and datatypes can be hard to correlate. This function makes it easier to create queries with datatypes specified.

Return Values:
Returns a query.

Example:

<cfset myQuery = typedQueryNew( {
   name = 'varchar',
   age = 'integer',
   address = 'varchar'
   } ) />

Parameters:

Full UDF Source:

/**
 * Function to easily create query objects with data types.
 * 
 * @param columnData      Structure of label/type fields for the query. (Required)
 * @return Returns a query. 
 * @author Ryan Stille (ryan@stillnet.org) 
 * @version 1, November 16, 2010 
 */
function typedQueryNew(columnData) {
    
    var columnname = "";
    var stringofColumns = "";
    var stringofTypes = "";
    var counter = 0;
    
    for (columnName in arguments.columnData) {
        counter++;
            
        stringOfColumns &= columnName;
        stringOfTypes &= arguments.columnData[columnName];
        if (counter NEQ StructCount(arguments.columnData)) {
            stringofColumns &= ", ";
            stringofTypes &= ", ";
            }
        }

    return queryNew(stringofColumns,stringofTypes);

    }