my $user = $schema->resultset('User')->single(
{
username => $q->param('username'),
password => $q->param('password')
},
{
select => [
\'userid, COUNT(*) as is_authorized',
],
}
);
should produce "SELECT userid, COUNT(*) as is_authorized FROM user WHERE username=? and password=?". Correct?
On 11/2/06, Brandon Black <[EMAIL PROTECTED]> wrote:
On 11/2/06, John Napiorkowski <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Not sure if I am doing this correctly. I am trying to
> order a result by the count of something but the 'as'
> parameter doesn't seem to do what I think it should
> do:
[...]
> Can anyone spot what I am doing wrong here?
From: http://search.cpan.org/dist/DBIx-Class/lib/DBIx/Class/ResultSet.pm#as :
Please note: This will NOT insert an AS employee_count into the SQL
statement produced, it is used for internal access only. Thus
attempting to use the accessor in an order_by clause or similar will
fail miserably.
To get around this limitation, you can supply literal SQL to your
select attibute that contains the AS alias text, eg:
select => [\'myfield AS alias']
-- Brandon
_______________________________________________
List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class
Wiki: http://dbix-class.shadowcatsystems.co.uk/
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/
Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
--
timorperfectus.com - web design to frightening perfection.
One last song
Given to an Angel's Son
As soon as you were gone
As soon as you were gone
_______________________________________________ List: http://lists.rawmode.org/cgi-bin/mailman/listinfo/dbix-class Wiki: http://dbix-class.shadowcatsystems.co.uk/ IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/trunk/DBIx-Class/ Searchable Archive: http://www.mail-archive.com/dbix-class@lists.rawmode.org/
