I beseech you to right my wrongs!
I am unable retrieve a row using DBIx::Class when specifying the datatype as 'datetime' to use with InflateColumns. The SQL that is generated gives me an error: "You have an error in your SQL syntax;" ... blah blah blah; the key error in the SQL is the datatype hash below:
SELECT me.id, me.token, me.old_invoice, me.date, me.=>, me.{data_type,
+ me.'datetime'} FROM invoices me ...
I am able to save date data flawlessly; I am also able to retrieve data from this field when I remove the datetime datatype from my column declaration. My Class is:
package SEM::Main::Invoices;
use base qw/DBIx::Class/;
__PACKAGE__->load_components(qw/PK::Auto InflateColumn::DateTime C
+ore/);
__PACKAGE__->table('invoices');
__PACKAGE__->add_columns(qw/id
token
old_invoice
date => {data_type => 'datetime'}
/);
__PACKAGE__->set_primary_key('id');
1;
My code retrieving the result set is:
my $rowI = $schema->resultset("Invoices")->search({token=>$sTarget
+})->first;
Any thoughts would be welcome;
TIA to those Monks of the digital cloth.
nybble