I posted something about this to the list awhile ago, and I agree with you
wholeheartedly. Here's an excerpt from my post, as the archives don't seem
to be up yet:
<cf_excerpt>
I too am interested in this project. I've been using SQL Server for most of
my sites and I generally use stored procedures for all of my database calls.
I'd like to see a system that can be used with any database, and can utilize
either inline SQL or stored procedures.
I believe that this isn't too difficult a task, if we define an interface to
the database. My suggestion would be that all SQL should sit in separate
files (e.g., qry files in Fusebox), and that the templates that call or
include those files would simply pass a standard set of variables to the
file, and would expect back a standard set of queries and/or return
variables. Then, those qry files could include inline SQL or calls to
stored procedures. If interested, different people can write these qry
files for specific databases, to utilize functions specific to those
databases and to optimize performance.
That way all of the pure CF functionality, including all of the UI, could be
written without any regard for the final database.
</cf_excerpt>
Bob
-----Original Message-----
From: Thomas Chiverton [mailto:[EMAIL PROTECTED]]
Sent: August 1, 2001 12:04 PM
To: CF_OpenSource
Subject: RE: CMS Project: Role call
> >In my opinion a open source CMS have to work with a open
> > source DB - I think
To be a success, the system must work on all databases - access, mySQL, DB2,
whatever.
I think I mentioned a database abstraction layer before...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
