• 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
  • Truncate Data
  • Change Sort Order
  • Save Many-to-Many Relationships
  • Synchronize Database Structure (ActiveSchema / loadXml)
    • Define a Column
    • Remove a Column
    • Remove a Table
  • Seed Data
• Advanced Functionality
  • Logging
  • Simulated Database
  • Specials
  • Relation Fields
    • Aggregates
    • Labels
    • Concatinations
    • Lists
  • Database Adaptor
• Informational Methods and Extra Functionality
  • 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
• Change Log
  • Change Log

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()