CODEWITHSUNDEEP
postgresqlcoldfusion
John Gagliardi
John Gagliardi

Reputation: 78

ColdFusion Illudium PU-36 Code Generator

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?

http://cfcgenerator.riaforge.org/

Upvotes: 2

Views: 244

Answers (1)

sweyrick
sweyrick

Reputation: 140

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>

Upvotes: 8

Related Questions