Hi all!
I'm displaying a view on a web page. The view contains a timestamp and a
date field. The database is MySQL 5.0.x.
As raw values from timestamp fields are no eye candy, I decided to use
DBIx::Class::InflateColumn::DateTime, using its default formatter to format
the timestamp. Unfortunately, it formats the date column, too. But as the
date column has no time information, I get something like
"YYYY-MM-DDT00:00:00". I don't want the time information.
Usually, I would format the date and timestamp within the sql statement, but
I wanted to try to format it in the ResultClass. So, how do I do that?
There is a handicap tough. Sure, I could iterate over each item of the
resultset and call some formatting routine for the date field. But I'm too
lazy to do that, because it looks a lot simpler to simply give the resultset
to the template (bzw, using HTML::Template::Compiled) and let the template
handle the output.
Here are some sniplets:
# code:
my $rs = $schema->resultset('View')->search(.);
$template->param(view_loop => $rs);
# template:
<TMPL_LOOP view_loop>
<TMPL_VAR column>
</TMPL_LOOP>
So, any suggestions?
_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]
