When generating models from postgresql with ColdFusion Illudium Code generator the boolean values get converted to varchar in the cfqueryparam and varchar gets converted to char. Does anyone have a fix for this issue?
1.open the file cfcgenerator/com/cf/model/datasource/postgresql.cfc
2.around line 63 replace bit/bool with this
<!--- bit / bool --->
<cfcase value="bit,boolean">
<cfreturn "cf_sql_bit" />
</cfcase>
<cfcase value="bool">
<cfreturn "cf_sql_varchar" />
</cfcase>
3.around line 101 replace strings with this
<!--- strings --->
<cfcase value="char">
<cfreturn "cf_sql_char" />
</cfcase>
<cfcase value="varchar,character varying,character">
<cfreturn "cf_sql_varchar" />
</cfcase>
<cfcase value="text">
<cfreturn "cf_sql_longvarchar" />
</cfcase>