[CDBI] Re: Trouble writing non-character fields

Edward J. Sabol sabol at alderaan.gsfc.nasa.gov
Tue Aug 9 00:04:06 BST 2005


> Hi All, I presume this information is somewhere on the old mailing list
> but I can't get to the archives, so I appreciate any guidance whatever
> ... I have Class::DBI working fine (with PostgreSQL) for everything but
> writing non-character values.
>
> If I try to write (for instance) a Date field, I get an error like:
[...]
> Do I need to explicitly do something with 'deflate' for these
> non-character types?

I think you need to tweak the SQL. Take a look at
http://wiki.class-dbi.com/index.cgi?SettingDefaultValues

If you have control over your database schema, another option is to make your
date fields char fields instead of a DBMS-specific date field. Then "deflate"
would work great and your code more portable to other database systems.

Hope this helps,
Ed




More information about the ClassDBI mailing list