vc precisa definir os alias para os campos! *NOTE:* You will almost always need a corresponding "as"<http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as> attribute when you use "select"<http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#select>, to instruct DBIx::Class how to store the result of the column. Also note that the "as"<http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as> 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 ORDER BY clause. This is done via the -as *select function attribute* supplied as shown in the example above.
2012/8/20 Jose Nilton <[email protected]> > Então eu posso fazer desse modo: > > $resultset->search ( undef, { select => [qw/ id login email active /] } > ) > > $rs = $schema->resultset('Employee')->search(undef, { select => ['name']}); > > > > > Em 20 de agosto de 2012 16:54, Renato Santos <[email protected]>escreveu: > > vc usa o $resultset->search ( undef, { select => [qw/ id login email >> active /], as => [qw/o_aidi o_login o_email active/] } >> >> lembrando que os prefetchs são tratados separadamente. >> >> Todos atributos estão em: >> >> http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#ATTRIBUTES >> >> vc tbm pode usar '+select' e '+as' pra adicionar mais campos na query. >> >> >> 2012/8/20 Jose Nilton <[email protected]> >> >>> Boa tarde a todos, >>> >>> Gostaria de saber como eu faço para listar só alguns campos da tabela: >>> >>> Exemplo: >>> >>> Banco: agencia >>> Tabelas: users >>> Campos: id, login, email, password, adm, active, create. >>> >>> Não quero selecionar todos os campos, quero id, login, email, active. >>> >>> Obrigado >>> >>> -- >>> ................................................................. >>> "Com Deus todas as coisas são possíveis" >>> >>> =begin disclaimer >>> Sao Paulo Perl Mongers: http://sao-paulo.pm.org/ >>> SaoPaulo-pm mailing list: [email protected] >>> L<http://mail.pm.org/mailman/listinfo/saopaulo-pm> >>> =end disclaimer >>> >>> >> >> >> -- >> Saravá, >> Renato CRON >> http://www.renatocron.com/blog/ >> @renato_cron <http://twitter.com/#%21/renato_cron> >> >> >> =begin disclaimer >> Sao Paulo Perl Mongers: http://sao-paulo.pm.org/ >> SaoPaulo-pm mailing list: [email protected] >> L<http://mail.pm.org/mailman/listinfo/saopaulo-pm> >> =end disclaimer >> >> > > > -- > ................................................................. > "Com Deus todas as coisas são possíveis" > > =begin disclaimer > Sao Paulo Perl Mongers: http://sao-paulo.pm.org/ > SaoPaulo-pm mailing list: [email protected] > L<http://mail.pm.org/mailman/listinfo/saopaulo-pm> > =end disclaimer > > -- Saravá, Renato CRON http://www.renatocron.com/blog/ @renato_cron <http://twitter.com/#!/renato_cron>
=begin disclaimer Sao Paulo Perl Mongers: http://sao-paulo.pm.org/ SaoPaulo-pm mailing list: [email protected] L<http://mail.pm.org/mailman/listinfo/saopaulo-pm> =end disclaimer
