com.sebtools.DataMgr_Access
Component DataMgr_Access (Data Manager for MS Access)


I manage data interactions with the MS Access database. I can be used/extended by a component to handle inserts/updates.


hierarchy: WEB-INF.cftags.component
      com.sebtools.DataMgr
            com.sebtools.DataMgr_Access
properties:
methods: getCreateSQL, getCFDataType, getDatabaseTables, getDBDataType, getDBTableStruct
inherited methods: init, addColumn, CreateTable, CreateTables, deleteRecord, getDatabase, getDatasource, getFieldList, getPKFields, getPKFromData, getRecord, getRecords, getStringTypes, getTableData, getUpdateableFields, getXML, insertRecord, loadTable, loadXML, saveRecord, saveRelationList, updateRecord
* - private method

getCreateSQL
public string getCreateSQL ( required string tablename )

I return the SQL to create the given table.

Output: supressed
Parameters:
   tablename: string, required, tablename - The name of the table to create.
getCFDataType
public string getCFDataType ( required string type )

I return the cfqueryparam datatype from the database datatype.

Output: supressed
Parameters:
   type: string, required, type - The database data type.
getDatabaseTables
public string getDatabaseTables ( )

I get a list of all tables in the current database.

Output: enabled
getDBDataType
public string getDBDataType ( required string CF_Datatype )

I return the database datatype from the cfqueryparam datatype.

Output: suppressed
Parameters:
   CF_Datatype: string, required, CF_Datatype

getDBTableStruct
public array getDBTableStruct ( required string tablename )

I return the structure of the given table in the database.

Output: supressed
Parameters:
   tablename: string, required, tablename