Am 15.01.2008 um 00:13 schrieb Michael Higgins:
Shouldn't this datetime cast/conversion thing be automagical?eval { $rs = $schema->resultset('DB::DATA')->search( {Name => {'like', $name_like}, "the date" => \"= cast ('01/4/2008' as datetime)" })}; I just can't figure out, I'm sure, where the syntax is documented for searching by datetime-type of column data via DBIx::Class.
Use DateTime and the following DBIC component for automatic inflating/ deflating to/from your database:
http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/InflateColumn/DateTime.pm --Tobias _______________________________________________ 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]
