• Introduction
  • What is DataMgr?
  • Exceptions
  • Contributions
• Basic Functionality
  • Getting Started
  • Structures in DataMgr
  • Save Data
  • Replace cfinsert/cfupdate
  • Replace SQL Inserts and Updates
  • Delete a Record
  • Get Records
  • Check Existence
  • Truncate Data
  • Change Sort Order
  • Save Many-to-Many Relationships
  • Update Multiple Records
  • Delete Multiple Records
  • Synchronize Database Structure (ActiveSchema / loadXml)
    • Define a Column
    • Remove a Column
    • Remove a Table
    • Define / Introspect Table
  • Seed Data
    • checkFields
  • Indexes
• Advanced Functionality
  • Logging
  • Simulated Database
  • Specials
    • Special Date Type
  • Relation Fields
    • Aggregates
    • Labels
    • Concatinations
    • Lists
    • Has / HasNot
    • Math
    • Now
    • Custom
  • "ftable"Attribute
  • Migrating Fields
  • Filters
  • Named Filters
  • Insert Custom SQL
  • SmartCache
  • Extending DataMgr
  • Database Adaptor
  • Is Deletable
• Informational Methods and Extra Functionality
  • Table Existence
  • Get Fields Meta Data
  • Run SQL Commands through DataMgr
  • Convert MS Word Character to ASCII
  • Get the Datasource that DataMgr is Using
  • Find out what Databases DataMgr supports
  • View DataMgr's Table Definitions
  • Get Methods SQL
  • Apply List Relations
• Change Log
  • Change Log

2.5 (March 3, 2013)

• Filters (and named filters)
• Paging (via an "offset" argument in the getRecords method)
  • Paging handling in the database: MS SQL 2005 +, MySQL, Oracle, PostGreSQL
  • For all others, the query is sliced in ColdFusion
• 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 Methods:
  • "hasRecords" method for efficient checking of existence of records matching criteria.
  • "numRecords" method to see how many records matching criteria.
  • New methods to return SQL used internally: getSelectSQL, getFromSQL, getWhereSQL, insertRecordsSQL, updateRecordsSQL. This is very useful with CF_DMQuery.
• Ability to extend DataMgr
• Ability to migrate fields - moving old data to new field names. Handy for renaming fields or easy migration from many-to-one relationship to a many-to-many one.
• loadXml():
  • Ability to introspect database tables.
  • New "ftable" attribute.
  • Major performance improvements for loadXml() (many for all database, some specific to SQL Server)
• 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
• Defaults for init() "datasource" argument:
  • Application.datasource, if defined
  • empty string (simulated database), otherwise
• 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
• Fixes
  • Fixed error on ColdFusion 9.0.1
  • Better handling of CFML Engine peculiarities
  • getDatabaseXml() now always accurately reports just the database schema.
  • Relation fields that use themselves now error instead of producing an infinite loop.
  • "maxrows" argument now works in Derby
  • Some small MS SQL specific improvements
  • Several small fixes

2.2 (January 25, 2009)

• Complete Documentation
• Automatic Database Detection
• New Supported Databases
  • Apache Derby
  • Oracle
• New Supported CFML Engines
  • Railo 3.0.1+
  • OpenBD 1.0+
• New Methods:
  • removeColumn
  • updateRecords
  • deleteRecords
  • getFieldLength
  • removeTable
  • getDefaultValues
  • getBooleanSqlValue
  • getDatabaseXml
• New Relation Field Types:
  • has
  • hasnot
  • math
  • now
• New getRecords() arguments
  • filters
  • advsql
• loadXml():
  • Added optional filters elements in relations.
  • New "checkFields" (and "onexists") attribute for seed data
• SmartCache (experimental feature)
• saveRelationList() now works on fields without a compound primary key

2.1 (July 10, 2007)

• Cascading Relation Fields
• Custom Relation Fields
• Optional "sort-field" attribute for "list" relation field to dictate order of list
• Optional "delimiter" attribute for "list" relation field
• DataMgr throws error for more than one "Increment" field in one table
• Report datasource name in loadXML() error
• Optional bidirectional self-relational many-to-many-relationships
• Optional "advsql" argument in getRecords

2.0 (April 9, 2007)

• Relation Fields
• Special Fields
  • DeletionMark (allows logical deletes)
  • CreationDate (tracks when record was first created)
  • LastUpdatedDate (tracks when last update was for record)
  • Sorter (allows DataMgr to automatically manage manual sort order)
• Username/password support
• Simulated Database
• Logging
• getRecords(): added "orderby" argument
• insertRecord(): "onexists" argument: added "save" option
• Added "setColumn()" method (deprecating "addColumn()")

1.2 (August 1, 2006)

• New deployment options
  • Can be instantiated from any directory
  • Can pass database type as second argument in init() for DataMgr.cfc
• Reports SQL on failed create or alter on a table
• getSupportedDatabases() returns recordset of databases supported by DataMgr.

1.1 (April 18, 2006)

• Added "getMaxRowsPrefix()"
• Added "getMaxRowsSuffix()"
• Added "getNewSortNum()"
• Added "saveSortOrder()"
• getRecords(): added "maxrows" argument
• loadXml(): Seed Data

1.0 (February 1, 2006)

• insertRecord()
• updateRecord()
• saveRelationList()
• getRecords()
• getRecord()
• loadXml()
• deleteRecord()
• truncate()
• addColumn()