DataMgr is a Data Access Layer component set.

http://steve.coldfusionjournal.com/announcing_datamgr_21.htm

More than anything else, DataMgr is meant to manage CRUD (that is, Create Read Update Delete). Everything else that it does is an extension of this.

Most solutions for CRUD work on one of two principals:

* ORM
* SQL Generation

Both of these have some code that writes other code and saves files. ORM requires an OO approach. If you are using a full OO approach, this is great. If not, it is a lot of extra work to get any benefit.

SQL Generation means that although you don't have to write the SQL, you still have a bunch of SQL in your code. This isn't a bad thing, but it can still leave you with much of the tedium of managing a bunch of SQL code in your application.

DataMgr takes a path of database abstraction. It doesn't generate any code or save any files. If you want to update a record (in your "products" table, say) from a form, just make sure that the form field names match the table field names and that you include the primary key value and then call updateRecord():

<cfset DataMgr.updateRecord("products",Form)>

The following page provides links to several blog entries as well as full documentation:

http://www.bryantwebconsulting.com/cfcs/#DataMgr

You can also watch my presentation to the Nashville CFUG:

http://mmusergroup.adobe.acrobat.com/p94317724/

12/3/08 DataMgr 2.2 Beta 3 (with Railo support!)
11/26/08 DataMgr List Relations
11/14/08 DataMgr SmartCache
10/22/08 DataMgr 2.2 Beta 2
7/30/08 Galleon on DataMgr

Server:
* Coldfusion MX 6.1+
* Railo 3.0.1+ (in DataMgr 2.2)

Databases:
* Access '97+
* MSSQL 2000+
* MySQL 4.1+
* PostGreSQL 8+
* Derby (in DataMgr 2.2)
* Oracle (in DataMgr 2.2)

ID	ISSUE	STATUS	UPDATED
4	List for one to many relations	Open	11/26/08 9:54 AM
3	Sort subGroup Enhancement	Fixed	07/10/07 11:04 AM
2	Common ID Solution for relations	Fixed	07/10/07 11:03 AM
1	Error if Data Struct Contains Object	Fixed	04/14/07 6:38 AM

View All Issues

To enter issues for this (or any other) project, you must be logged in.