RE: Deploying to Multiple Databases

I try to avoid needing platform-specific sql during the app's initial construction.May be too late or impossible for you to go down that road. Using CF to produce things like the date value from your example instead of using the db's native functions eliminates the need to worry about db-specific

RE: Deploying to Multiple Databases

- From: Jim Davis [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 1:24 AM To: CF-Talk Subject: RE: Deploying to Multiple Databases Using CFCs I do this: I've got a DPDataSource CFC which has four proerties: DSNName, DBType, UserName and Password. The DBType is the important bit.For

RE: Deploying to Multiple Databases

with a better system (but don't forget to do the optimization phase at the end!) Jim Davis -Original Message- From: Haggerty, Mike [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 11:26 AM To: CF-Talk Subject: RE: Deploying to Multiple Databases Jim - Thanks

RE: Deploying to Multiple Databases

Using CFCs I do this: I've got a DPDataSource CFC which has four proerties: DSNName, DBType, UserName and Password. The DBType is the important bit.For example, it may be MSSQLServer2000 and determines which codebase to use. Now, I place all of my data access methods into a broker CFC