FAQ
I am trying to do a group concat select statement in DBIx class, is
this possible??

I have the statement:

select fam_acc, subf, group_concat(concat(description, " (EC
",ec_num,")") separator '; ') from family inner join fam_func
using(fam_id) inner join function using(function_id) where fam_acc =
'GH2' and subf is NULL group by fam_id order by ec_num;

And I have the search statement:

$fam_desc_search = $family_rs->search({fam_acc=>$fam,subf=>$sfam},
{join=>{'fam_func'=>'function'},
order_by=>[qw/'ec_num'/],
group_by=>[qw/'fam_id'/]
}
);

How do I get the group_concat/concat in the results? +select?

Brandi

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbix-class @
categoriesperl, catalyst
postedJan 19, '09 at 10:36a
activeJan 19, '09 at 10:36a
posts1
users1
websitedbix-class.org
irc#dbix-class

1 user in discussion

Brandi: 1 post

People

Translate

site design / logo © 2021 Grokbase