vc precisa definir os alias para os campos!<br><p style="font-family:arial,sans-serif;background-color:rgb(255,255,255)"><b>NOTE:</b> You will almost always need a corresponding <a href="http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as" class="podlinkpod" style="background-color:transparent;color:rgb(0,102,153)">"as"</a> attribute when you use <a href="http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#select" class="podlinkpod" style="background-color:transparent;color:rgb(0,102,153)">"select"</a>, to instruct DBIx::Class how to store the result of the column. Also note that the <a href="http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as" class="podlinkpod" style="background-color:transparent;color:rgb(0,102,153)">"as"</a> attribute has nothing to do with the SQL-side 'AS' identifier aliasing. You can however alias a function, so you can use it in e.g. an <code>ORDER BY</code> clause. This is done via the <code>-as</code> <b>select function attribute</b> supplied as shown in the example above.</p>
<div><br></div><div><br></div><div class="gmail_quote">2012/8/20 Jose Nilton <span dir="ltr"><<a href="mailto:jniltinho@gmail.com" target="_blank">jniltinho@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Então eu posso fazer desse modo:<br><br> $resultset->search ( undef, { select => [qw/ id login email
active /] } ) <br><br><pre><span>$rs</span> <span>=</span> <span>$schema</span><span>-></span><span>resultset</span><span>(</span><span>'Employee'</span><span>)-></span><span>search</span><span>(</span><span>undef</span><span>,</span> <span>{</span> <span>select</span> <span>=></span> <span>[</span><span>'name'</span><span></span><span>]</span><span>}</span><span>);</span></pre>
<br><br><br><div class="gmail_quote">Em 20 de agosto de 2012 16:54, Renato Santos <span dir="ltr"><<a href="mailto:renato.cron@gmail.com" target="_blank">renato.cron@gmail.com</a>></span> escreveu:<div><div class="h5">
<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
vc usa o $resultset->search ( undef, { select => [qw/ id login email active /], as => [qw/o_aidi o_login o_email active/] } <div><br></div><div>lembrando que os prefetchs são tratados separadamente.</div><div>
<br></div><div>Todos atributos estão em:<br><a href="http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#ATTRIBUTES" target="_blank">http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#ATTRIBUTES</a></div>
<div>
<br></div><div>vc tbm pode usar '+select' e '+as' pra adicionar mais campos na query.</div><div><br><br><div class="gmail_quote">2012/8/20 Jose Nilton <span dir="ltr"><<a href="mailto:jniltinho@gmail.com" target="_blank">jniltinho@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Boa tarde a todos,<br><br>Gostaria de saber como eu faço para listar só alguns campos da tabela:<br>
<br>Exemplo:<br><br>
Banco: agencia<br>Tabelas: users<br>Campos: id, login, email, password, adm, active, create.<br><br>Não quero selecionar todos os campos, quero id, login, email, active.<br>
<br>Obrigado<span><font color="#888888"><br clear="all"><br>-- <br>.................................................................<br> "Com Deus todas as coisas são possíveis"<br>
</font></span><br></div></div>=begin disclaimer<br>
Sao Paulo Perl Mongers: <a href="http://sao-paulo.pm.org/" target="_blank">http://sao-paulo.pm.org/</a><br>
SaoPaulo-pm mailing list: <a href="mailto:SaoPaulo-pm@pm.org" target="_blank">SaoPaulo-pm@pm.org</a><br>
L<<a href="http://mail.pm.org/mailman/listinfo/saopaulo-pm" target="_blank">http://mail.pm.org/mailman/listinfo/saopaulo-pm</a>><br>
=end disclaimer<br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><div><br></div>-- <br><div><span style="color:rgb(51,51,51);font-size:x-small">Saravá,</span></div><div><span style="color:rgb(51,51,51);font-size:x-small">Renato CRON</span></div>
<div><div style="text-align:right"><font color="#333333" size="1"><a href="http://www.renatocron.com/blog/" target="_blank">http://www.renatocron.com/blog/</a></font></div></div><div style="text-align:right"><font color="#333333" size="1"><a href="http://twitter.com/#%21/renato_cron" target="_blank">@renato_cron</a></font></div>
<br>
</font></span></div>
<br>=begin disclaimer<br>
Sao Paulo Perl Mongers: <a href="http://sao-paulo.pm.org/" target="_blank">http://sao-paulo.pm.org/</a><br>
SaoPaulo-pm mailing list: <a href="mailto:SaoPaulo-pm@pm.org" target="_blank">SaoPaulo-pm@pm.org</a><br>
L<<a href="http://mail.pm.org/mailman/listinfo/saopaulo-pm" target="_blank">http://mail.pm.org/mailman/listinfo/saopaulo-pm</a>><br>
=end disclaimer<br>
<br></blockquote></div></div></div><div class="HOEnZb"><div class="h5"><br><br clear="all"><br>-- <br>.................................................................<br> "Com Deus todas as coisas são possíveis"<br>
</div></div><br>=begin disclaimer<br>
Sao Paulo Perl Mongers: <a href="http://sao-paulo.pm.org/" target="_blank">http://sao-paulo.pm.org/</a><br>
SaoPaulo-pm mailing list: <a href="mailto:SaoPaulo-pm@pm.org">SaoPaulo-pm@pm.org</a><br>
L<<a href="http://mail.pm.org/mailman/listinfo/saopaulo-pm" target="_blank">http://mail.pm.org/mailman/listinfo/saopaulo-pm</a>><br>
=end disclaimer<br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><div><span style="color:rgb(51,51,51);font-size:x-small">Saravá,</span></div><div><span style="color:rgb(51,51,51);font-size:x-small">Renato CRON</span></div>
<div><div style="text-align:right"><font size="1" color="#333333"><a href="http://www.renatocron.com/blog/" target="_blank">http://www.renatocron.com/blog/</a></font></div></div><div style="text-align:right"><font size="1" color="#333333"><a href="http://twitter.com/#!/renato_cron" target="_blank">@renato_cron</a></font></div>
<br>