ObjectDAO

ObjectDAO

ObjectDAO

I read Object data from a MySQL4 database.

Metadata

Instantiating 






CreateFarcryPackage()


Arguments






Name
Type
Required
Default
Options
Description






typename
string
Yes







DSN
string
Yes


I am the CF datasource name






getCfDataType()
I translate the MSSQL data type names into ColdFusion data type names


Arguments






Name
Type
Required
Default
Options
Description






typeName
string
Yes


I am the type name to translate






getCfSqlType()
I translate the MSSQL data type names into ColdFusion cf_sql_xyz names


Arguments






Name
Type
Required
Default
Options
Description






typeName
string
Yes


I am the type name to translate






getDBObjects()


Arguments






Name
Type
Required
Default
Options
Description






DSN
string
Yes


I am the CF datasource name






getDefault()
I get a default value for a cf datatype.


Arguments






Name
Type
Required
Default
Options
Description






sqlDefaultValue
string
Yes


I am the default value defined by SQL.




typeName
string
Yes


I am the cf type name to get a default value for.




nullable
boolean
Yes


I indicate if the column is nullable.






readFields()
I populate the table with fields.


Arguments






Name
Type
Required
Default
Options
Description






qObject
query
Yes









readObject()
I confirm that this object exists at all. If not, I throw an error.


Arguments






Name
Type
Required
Default
Options
Description






DSN
string
Yes


I am the CF datasource name




ObjectName
string
Yes


I am the object to check on.