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 of
the control panel they run it's not a possibility at the moment.
So what I've done is created a MS SQL version of the database. In the
entire site there are only two queries that have to be changed for the
different databases (MSSQL concatenates differently than MySQL). Other than
that everything else is playing nicely together.
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 go about
this?
FWIW this is all running on Windows servers using CFMX 6.0 and 6.1.
Thanks!
Hatton
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.559 / Virus Database: 351 - Release Date: 1/7/2004
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
