Subscribe to DataMgr |
Visit this group |
Although DataMgr allows you to write code that will run the same across multiple CFML engines and databases, it does have a few exceptions of which you should be aware.
DataMgr cannot introspect the database unless read permissions are enabled in Access on system tables. Active Schema should still work though.
As MySQL doesn't have a data type specifically for boolean data, DataMgr follow the convention of using the "tinyint" data type for this purpose. As a consequence, DataMgr will not store numeric data in this field - instead limiting values to 1 and 0.