--- Ash Berlin <[EMAIL PROTECTED]> wrote:
> Kevin Old wrote:
> > Hello everyone,
> >
> > I'm trying to use the hack defined in the FAQ for
> "sort my results
> > based on fields I've aliased using as" with the
> following statement
> > which includes a count.
> >
> > $schema->resultset("MyTable")->search(undef, {
> select => [ { count =>
> > 'list_id'} ], as => [ 'list_count' ] });
> >
> > Can someone give me the syntax for this statement
> for the hack? I've
> > tried just about every combination of inserting \'
> as list_count' but
> > nothing seems to work.
> >
> > Any help is greatly appreciated,
> > Kevin
> >
> Define doesn't work.
>
> If you mean $rs->list_count says no such method,
> then yes - it doesn't
> create an accessor for it. to
> $rs->get_column('list_count')
>
> If you mean the query doesn't run, then please tell
> us what error it gives.
>
> Ash
I have something similar where I try to get the max
value for a given column and I also had trouble
getting it to work. The key was to remember that you
have a resultset returned, not a row. Here's how I do
it (It's a catalyst based example but should work
similarly:
my $params = {
select => {MAX => 'updated' },
as => 'updated',
}
my $newest = $c->model('db::members')->search(undef,
$params);
my $updated = newest->single->updated;
You have to remember that search returns a resultset
which you need to iterate against, even if there is
one value.
you could also (probably) do:
my ($first) = $c->model('db::members')->search(undef,
$params)->all;
my $updated = $first->updated;
I just usually stay away from ->all;
--john
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
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]/
