RE: Determining Database Type

2004-01-14 Thread Hugo Ahlenius
- | From: C. Hatton Humphrey [mailto:[EMAIL PROTECTED] | Sent: Tuesday, January 13, 2004 14:39 | To: CF-Talk | Subject: Determining Database Type | | I'm working on an application where I need to provide support | for both MySQL and MSSQL databases.  This is because our | devel and produ

Re: Determining Database Type

2004-01-13 Thread Nick de Voil
> What I'm wondering, though, is if there is a way for me to run a query in my > application.cfm to determine the version of the database I'm running.  At > the moment I'm exploring using a CFCatch around a specific MySQL query > (select version()), but does anyone have any better ideas of how to g

Determining Database Type

2004-01-13 Thread C. Hatton Humphrey
I'm working on an application where I need to provide support for both MySQL and MSSQL databases.  This is because our devel and production environments are both running MySQL 4.x on Windows but our staging/code share server is running MySQL 3.23 on Linux.  They're working on upgrading but because