[CDBI] Re: Trouble writing non-character fields

[prev] [thread] [next] [Date index for 2005/08/08]

> 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

_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi