CFLib.org – IsDatasource

IsDatasource(nameToCheck)

Last updated June 21, 2002

Download UDF

author

Nathan Dintenfass
Send Email

Version: 1 | Requires: ColdFusion MX | Library: UtilityLib

Rated 1 time(s). Average Rating: 5.0

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

Return Values:
Returns a boolean.

Example:

view plain print about

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

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

Parameters:

Name	Description	Required
nameToCheck	DSN to check for.	Yes

Full UDF Source:

	
	
			
			
			
				
				view plain
				
				
				copy to clipboard
				
				
				
				
				print
				
				
				about
				ColdFISH is developed by Jason Delmore.  Source code and license information available at coldfish.riaforge.org.  Version 3.1.1
				
			<cfscript>
/**
 * Returns a boolean if the datasource name exists.
 * 
 * @param nameToCheck 	 DSN to check for. (Required)
 * @return Returns a boolean. 
 * @author Nathan Dintenfass (&#110;&#97;&#116;&#104;&#97;&#110;&#64;&#99;&#104;&#97;&#110;&#103;&#101;&#109;&#101;&#100;&#105;&#97;&#46;&#99;&#111;&#109;) 
 * @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);
}
</cfscript>
		<cfscript>
/**
 * 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);
}
</cfscript>