Re^3: Class::DBI weirdness sql error

Thanks for the help.
In the end it took some debugging to find the very very very silly mistake that I made. Here's a hint, it's in this piece...

# within FS::Model::Items->new();
$self->table('items');
$self->columns( 
    qw/item item_type name lng lat zip url phone fax address/
    );
[download]

Yea, my columns definition is wrong. It's expecting a hash with the id being 'All'. So,

# within FS::Model::Items->new();
$self->table('items');
$self->columns( All =>
    qw/item item_type name lng lat zip url phone fax address/
    );
[download]

Done. It works. Boo carelessness.

Comment on Re^3: Class::DBI weirdness sql error Select or Download Code

Replies are listed 'Best First'.
Re^4: Class::DBI weirdness sql error by trwww (Priest) on Mar 04, 2009 at 05:34 UTC
:0) Thanks for letting us know. It is surprising to me that you can use InsideOut with it. If you get a chance, please let us know how it works out! Regards,	[reply]
Re^5: Class::DBI weirdness sql error by JavaFan (Canon) on Mar 04, 2009 at 10:27 UTC
It is surprising to me that you can use InsideOut with it. It's my understanding that InsideOut only wants the parent class to implement objects with references. And since all Perl objects are blessed references, I'm not surprised you can use InsideOut to subclass Class::DBI.	[reply]
Re^4: Class::DBI weirdness sql error by JavaFan (Canon) on Mar 04, 2009 at 10:24 UTC
You're not passing a hash; colums takes a list, of which the first element tells what kind of columns the rest are. If it were a hash, you'd would have had key value pairs like "item_type => 'name'", "lng => 'zip'", etc. Which I doubt you want.	[reply]