CFLib.org – Common Function Library Project

Description:
Pass in a string, get a boolean back telling you if a datasource of that name exists.

Return Values:
Returns a boolean.

Example:

<cfoutput>#isDatasource("cfsnippets")#</cfoutput>

Parameters:

Full UDF Source:

/**
 * Returns a boolean if the datasource name exists.
 * 
 * @param nameToCheck      DSN to check for. (Required)
 * @return Returns a boolean. 
 * @author Nathan Dintenfass (nathan@changemedia.com) 
 * @version 1, June 21, 2002 
 */
function isDatasource(nameToCheck) {
    //grab the datasourceService object
    var dsObj = createObject("Java","coldfusion.server.ServiceFactory");
    //check if the name is one of the datasources
    return structKeyExists(dsObj.datasourceService.getDatasources(),nameToCheck);
}