• 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

DataMgr Information

Download from RIA Forge

API Documentation

XML Schema

Demonstration Site

Blog Entries

DataMgr CFC Docs

Subscribe to DataMgr

Email:

Visit this group

Specials

DataMgr has a selection of special functions that it can perform on selected columns. These can be defined either using the "Special" attribute of the "field" tag in the XML passed to loadXML() or it can be defined using the "Special" argument of the setColumn() method.

• CreationDate
  • Only used with CF_SQL_DATE
  • DataMgr will automatically put the current date/time when inserting a record if no value is passed in for this field.
• LastUpdatedDate
  • Only used with CF_SQL_DATE
  • DataMgr will automatically put the current date/time when inserting or updating a record if no value is passed in for this field.
• DeletionMark
  • Only used with CF_SQL_BIT or CF_SQL_DATE
  • DataMgr will only retrieve records where this field is 0 (zero) for CF_SQL_BIT or NULL for either type.
  • If a table has a DeletionMark field, DataMgr will use it (setting it to true for CF_SQL_BIT or to the current date for CF_SQL_DATE) instead of deleting a record when calling deleteRecord().
• Sorter
  • Only used with CF_SQL_INTEGER
  • If no orderby argument is passed to getRecords(), this field will be the order by field.
  • When inserting a record, DataMgr will automatically assign this field to the next highest value (one higher than the highest value in the table) if no other value is passed in.
• UUID
  • Only used with character fields such as CF_SQL_VARCHAR or CF_SQL_CHAR
  • DataMgr will automatically put in a UUID when inserting a record if no value is passed in for this field.