当使用ColdFusion Illudium代码生成器从PostgreSQL生成模型时,布尔值在cfqueryparam中被转换为varchar,而varchar被转换为char。有谁有解决这个问题的办法吗?
http://cfcgenerator.riaforge.org/
发布于 2012-04-05 02:23:16
1.打开文件cfcgenerator/com/cf/model/datasource/postgresql.cfc
2.在第63行附近,将bit/bool替换为
<!--- bit / bool --->
<cfcase value="bit,boolean">
<cfreturn "cf_sql_bit" />
</cfcase>
<cfcase value="bool">
<cfreturn "cf_sql_varchar" />
</cfcase>3.在第101行周围,将字符串替换为以下内容
<!--- 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>https://stackoverflow.com/questions/10017009
复制相似问题