> I am sure there is probably a hidden tag to get the list of CF
> datasources?
> Does any one know how to retrieve these in a CFML page?
- decrypted from the ODBC index.cfm of CF Admin -
<!----------------- Get all registered System ODBC data
sources. --------------->
<CFIF Request.Server_OS_Name IS NOT "UNIX">
<CFREGISTRY ACTION=SET BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC"
ENTRY="ODBC.INI" TYPE="KEY">
<CFREGISTRY ACTION=SET BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC"
ENTRY="ODBCINST.INI" TYPE="KEY">
<CFREGISTRY ACTION=SET
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI" ENTRY="ODBC Data Sources"
TYPE="KEY">
<CFREGISTRY ACTION=SET
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI" ENTRY="ODBC Drivers"
TYPE="KEY">
<CFPARAM Name="Sort" Default="Entry">
<CFREGISTRY ACTION=GETALL NAME="DS_List" TYPE="ANY" SORT="#Sort#"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ODBC Data Sources">
<CFREGISTRY ACTION=GETALL NAME="Drivers"
BRANCH="HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers">
<CFELSE>
<CFSET DS_List = cfusion_getodbcdsn()>
</CFIF>
The DS_List query should then contain the ODBC driver list;
In non-UNIX
Entry is the name
Value is the ODBC type
In UNIX
Name is the name
Description is the ODBC type
Philip Arnold
Director
Certified ColdFusion Developer
ASP Multimedia Limited
T: +44 (0)20 8680 1133
"Websites for the real world"
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
**********************************************************************
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
