• 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

Getting Started

To use DataMgr, follow these steps:

1. Download DataMgr
2. Place it where you want to store it (code example assumes root of site or CustomTags directory).
3. Initialize DataMgr

Application.DataMgr = CreateObject("component","DataMgr").init("mydsn")

Note that "mydsn" in this example is the datasource. That could also be a variable that holds the value of your datasource.

If you don't have Java access enabled, you will have to specify the database as well:

Application.DataMgr = CreateObject("component","DataMgr").init("mydsn","MSSQL")

DataMgr can also be instantiated with no datasource argument at all. If Application.datasource exists, it will use that as a default. Otherwise, it will use the simulated database.

Application.DataMgr = CreateObject("component","DataMgr").init()

The "init" method has the following arguments.

• datasource (optional): The datasource that DataMgr will use (if omitted, DataMgr will use Application.datasource or an empty string).
• database (optional): The DBMS engine for the datasource
• username (optional): The username for the datasource
• password (optiona): The password for the datasource
• SmartCache (default: false)
• SpecialDateType (default: CF)
• XmlData (optional): If present, automatically passed to loadXml method.

CFC Docs