[thelist] CF: Determining which DB used.

Seth Bienek seth at sethbienek.com
Wed Sep 12 11:07:53 CDT 2001

Hi Frank,

> The specific case that Access uses 'Yes' and 'No' for booleans, 
> whereas MySQL uses '1' and '0'. I was hoping that I could have the 
> app automatically detect it.

Access uses '1' and '0' as well.  It's just 'Yes' and 'No' friendly, too. :)

Also, if you know the name of the datasource, you can pull the datasource type out of the registry:

<cfregistry action = "get"
	branch = "HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.ini\ODBC Data Sources"
	type = "string"
	variable = "DataType"> 




More information about the thelist mailing list