• 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
  • Update Multiple Records
  • Delete Multiple Records
  • Synchronize Database Structure (ActiveSchema / loadXml)
    • Define a Column
    • Remove a Column
    • Remove a Table
  • Seed Data
    • checkFields
• Advanced Functionality
  • Logging
  • Simulated Database
  • Specials
  • Relation Fields
    • Aggregates
    • Labels
    • Concatinations
    • Lists
    • Has / HasNot
    • Math
    • Now
    • Custom
  • Filters
  • Insert Custom SQL
  • SmartCache
  • Database Adaptor
• Informational Methods and Extra Functionality
  • 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
• Change Log
  • Change Log

DataMgr Information

Download from RIA Forge

API Documentation

XML Schema

Demonstration Site

Blog Entries

Subscribe to DataMgr

Email:

Visit this group

Get Methods SQL

DataMgr provides the ability to see what SQL array it will use for the "getRecords" (or "getRecord") method. To get this information, simply call the "getRecordsSQL" method with the same arguments that you would pass to the "getRecords" method.