<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:18pt"><font size="3">this straight lift from documentation is not working. what could i be doing wrong?<br><br></font><pre class="sh_perl sh_sourceCode"> <span class="sh_keyword">my</span> <span class="sh_variable">@all_artists</span> <span class="sh_symbol">=</span> <span class="sh_variable">$schema</span><span class="sh_symbol">-></span><span class="sh_function">resultset</span><span class="sh_symbol">(</span><span class="sh_string">'Artist'</span><span class="sh_symbol">)-></span><span class="sh_function">search</span><span class="sh_symbol">(</span><span class="sh_keyword">undef</span><span class="sh_symbol">,</span> <span class="sh_cbracket">{</span>
columns <span class="sh_symbol">=></span> <span class="sh_symbol">[</span><span class="sh_keyword">qw</span><span class="sh_string">/name artistid/</span><span class="sh_symbol">],</span>
<span class="sh_cbracket">}</span><span class="sh_symbol">);<br><br><br>my query is:<br> my @items = $schema->resultset('Itemlist')->search(<br> undef, #no search condition means all records<br> { select => [qw/itemid item/] }<br> );<br> print @items;<br></span></pre>the output is count of rows in the table, and not the data requested. when i try to print the array via this loop:<br><br><pre>foreach (@items) {
print "$_\n";
}</pre>I get this output...<br><br>Itemdb::Schema::Result::Itemlist=HASH(0x90c7000)<br>Itemdb::Schema::Result::Itemlist=HASH(0x90c73a0)<br>Itemdb::Schema::Result::Itemlist=HASH(0x90c7190)<br>Itemdb::Schema::Result::Itemlist=HASH(0x90c70f0)<br>Itemdb::Schema::Result::Itemlist=HASH(0x90c6f60)<br>Itemdb::Schema::Result::Itemlist=HASH(0x90c27a0)<br>.....<br><br>ty.<br>Rajeev<br><div><br></div></div></body></html>