[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"
entry="#Application.DS#"
type = "string"
variable = "DataType">
<cfoutput>#DataType#</cfoutput>
HTH,
Seth
More information about the thelist
mailing list