this straight lift from documentation is not working. what could i be doing
wrong?
my @all_artists = $schema->resultset('Artist')->search(undef, { columns =>
[qw/name artistid/], });
my query is:
my @items = $schema->resultset('Itemlist')->search(
undef, #no search condition means all records
{ select => [qw/itemid item/] }
);
print @items;
the output is count of rows in the table, and not the data requested. when i
try to print the array via this loop:
foreach (@items) { print "$_\n";
}I get this output...
Itemdb::Schema::Result::Itemlist=HASH(0x90c7000)
Itemdb::Schema::Result::Itemlist=HASH(0x90c73a0)
Itemdb::Schema::Result::Itemlist=HASH(0x90c7190)
Itemdb::Schema::Result::Itemlist=HASH(0x90c70f0)
Itemdb::Schema::Result::Itemlist=HASH(0x90c6f60)
Itemdb::Schema::Result::Itemlist=HASH(0x90c27a0)
.....
ty.
Rajeev
_______________________________________________
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/dbix-class@lists.scsys.co.uk