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/[email protected]/
