DataMgr

DataMgr is a wrapper around basic CRUD (Create Read Update Delete) database operations allowing developers to easily write code that connects and then modifies data stored inside a database.

On top of this, developers can also use DataMgr to define a database's structure through ColdFusion code, and also generate fake data to test and prototype various applications.

This allows it to work best with relational databases, an alternative to the classic ORM approach.

Supported database engines:
- Apache Derby
- MS Access
- MS SQL Server
- MySQL
- Oracle
- PostgreSQL

What is new in this release:

• Special Date Type setting
• Special="UUID": Set the value of the field to a UUID if no value is passed in on an insert.
• SQL Server: Added support for varchar(max) (and made it the default for LONGVARCHAR).
• New "applyListRelations" method (take tablename,query) for post-calculation of list relations for getRecords() - also useful with CF_DMQuery
• Optional "XmlData" argument to "init" method (calls "loadXml" automatically)
• Ability to check for table existence.
• Improved MS Word cleanup
• Support for managing Indexes
• Optional "fieldlist" argument to limit the data that can be changed while saving data.
• Optional "truncate" argument to automatically truncate data to fit in database while saving data.
• For tables with a simple (single-field) primary keys, the ability to pass a single value into the "data" argument for getRecords() instead of a structure of values.
• New "isDeletable" calculated field available to "getRecords" determines if each record can be deleted based on "onDelete" property of relation fields.
• Ability to exclude columns from multi-row get queries (see useInMultiRecordsets).
• "advsql" argument now available for update methods

Requirements:

• Coldfusion MX 6.1 or higher
• OpenBD 1.0 or higher
• Railo 3.0.1 or higher
• Access '97 or higher
• MSSQL 2000 or higher
• MySQL 4.1 or higher
• PostGreSQL 8 or higher
• Derby
• Oracle