CFLib.org – GetDSNs

GetDSNs()

Last updated November 15, 2002

Download UDF

author

Raymond Camden
Send Email

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

Rated 0 time(s). Average Rating: 0

Description:
Gets a list of registered datasources.

Return Values:
Returns an array.

Example:

view plain print about

<!---
Commented out for security reasons.
<cfdump var="#getDSNs()#">
--->

Parameters:

No arguments.

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>
/**
 * Gets a list of DSNs.
 * 
 * @return Returns an array. 
 * @author Raymond Camden (&#114;&#97;&#121;&#64;&#99;&#97;&#109;&#100;&#101;&#110;&#102;&#97;&#109;&#105;&#108;&#121;&#46;&#99;&#111;&#109;) 
 * @version 1, November 15, 2002 
 */
function getDSNs() {
	var factory = createObject("java","coldfusion.server.ServiceFactory");
	return factory.getDataSourceService().getNames();
}
</cfscript>
		<cfscript>
/**
 * Gets a list of DSNs.
 * 
 * @return Returns an array. 
 * @author Raymond Camden (ray@camdenfamily.com) 
 * @version 1, November 15, 2002 
 */
function getDSNs() {
    var factory = createObject("java","coldfusion.server.ServiceFactory");
    return factory.getDataSourceService().getNames();
}
</cfscript>