DBIx::Browse::CGI and boolean on Postgresql
- From: "Otavio" <otavio.pereira@xxxxxxxxx>
- Date: 3 Oct 2006 10:23:12 -0700
Hello there!
I´m implementing an interface for a table in postgres using the
DBIx::Browse::CGI... it´s very good... with a 30 line code I´m able
to list the entire contents of a table, filter these contents by
(almost - back to it later) any field in the table and edit them
individually.
Now comes the forementioned almost. It doesn´t work well with boolean
types, since it uses the database patern matching operator '~*' that
doesn´t work on boolean fields. Any idea for this problem short of
altering the database for a char type?
Error Message: "Error from database: ERROR: Unable to identify an
operator '~*' for types 'boolean' and '"unknown"'
At DBIx::Browse::CGI, /usr/lib/perl5/site_perl/5.8.0/DBIx/Browse/CGI.pm
line 142."
Another problem I have is when trying to update the data. My primary
key has both letters and digits, whenever I try to update the data, it
down cases all the letters in the form and tries to match (again the
*~) against the uper case stored ones. Any ideas on that short of
editing the module?
Error Message: "rror from database: ERROR: Attribute "aaa17333" not
found
At DBIx::Browse, /usr/lib/perl5/site_perl/5.8.0/DBIx/Browse.pm line
454."
Thanks a bunch,
-Otávio
.
- Prev by Date: Re: How to define port number with DB2 ODBC driver?
- Next by Date: Problem with DBD::Oracle 1.18 on Mac OS X with Oracle Instant Client
- Previous by thread: How to define port number with DB2 ODBC driver?
- Next by thread: Problem with DBD::Oracle 1.18 on Mac OS X with Oracle Instant Client
- Index(es):