Changeset 2661

Timestamp:

10/01/09 00:02:45 (4 years ago)

Author:

lmajano

Message:

new db appender property type to choose text fields

Location:

coldbox/trunk/system/logging

Files:

• appenders/DBAppender.cfc (modified) (3 diffs)
• readme.txt (modified) (1 diff)

coldbox/trunk/system/logging/appenders/DBAppender.cfc

@@ -18 +18 @@
  - autocreate : if true, then we will create the table. Defaults to false (Optional)
  - ensureChecks : if true, then we will check the dsn and table existence.  Defaults to true (Optional)
-        
+ - textDBType : Defaults to 'text'. This is used on the autocreate features of the appender for the
+                                   message and extended info fields.  This is the actual database type.
+                                   
 The columns needed in the table are
 
@@ -65 +67 @@
                         if( NOT propertyExists("ensureChecks") ){
                                 setProperty("ensureChecks",true);
+                        }
+                        if( NOT propertyExists("textDBType") ){
+                                setProperty("textDBType","text");
                         }
                         
@@ -169 +174 @@
                                         #listgetAt(cols,4)# DATETIME NOT NULL,
                                         #listgetAt(cols,5)# VARCHAR(100) NOT NULL,
-                                        #listgetAt(cols,6)# TEXT,
-                                        #listgetAt(cols,7)# TEXT,
+                                        #listgetAt(cols,6)# #getProperty("textDBType")#,
+                                        #listgetAt(cols,7)# #getProperty("textDBType")#,
                                         PRIMARY KEY (id)
                                 )

coldbox/trunk/system/logging/readme.txt

@@ -78 +78 @@
 == Version 1.0 RC 2 (October 2009) ==
  * Fix for adding categories via XML
+ * DBAppender new property textDBType to choose the text db type instead of the default 'text'
 
 == Version 1.0 Beta (August, 2009) ==