List registered datasources 1

[gArmitage]

Hi,

Does anyone know how to get a list of registered datasources in Coldfusion?

The reason? I'm writting a little program to display infomation about the tables/columns in a client installation (some clients have a habit of changing the database and _not_ telling us), so I can see whether anything has been altered.

Many thanks,

Grahame

 

[tleish]

The following code only works if CFREGISTRY tag is enabled in the ColdFusion Administrator

<CFREGISTRY ACTION=&quot;GETALL&quot; NAME=&quot;qDataSources&quot;
TYPE=&quot;ANY&quot; SORT=&quot;Entry&quot;
BRANCH=&quot;HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\odbc.ini\ODBC Data Sources&quot;>

<CFOUTPUT QUERY=&quot;qDataSources&quot;>
#qDataSources.Entry#[COLOR=000080]<br>[/color]
</cfoutput> - tleish

 

[gArmitage]

Thanks very much.

It does exactly what is says on the tin!!!! s-)

Cheers,

Grahame

 

[strantheman]

Hey g, then why no vote for our friend tleish and his time?

I gave him a star, why not you?

 

[tleish]

Thanks for the star strantheman - tleish