[CDBI] Group by and AbstractSearch

yoorobot at gmail.com yoorobot at gmail.com
Fri Oct 21 17:01:17 BST 2005


select_val is documented here:
http://search.cpan.org/dist/Class-DBI/lib/Class/DBI.pm#select_val

documentation regarding custom sql:
http://search.cpan.org/dist/Class-DBI/lib/Class/ 
DBI.pm#DEFINING_SQL_STATEMENTS

On Oct 21, 2005, at 10:42 AM, Brett Sanger wrote:

> On Fri, Oct 21, 2005 at 07:48:00AM -0700, Bill Moseley wrote:
>
>>> sub area_summary {
>>>   my $self = shift;
>>>   my $sql = SQL::Abstract->new();
>>>   my ($where, @bind) = $sql->where(@_);
>>>   return $self->sql_summarize($where)->select_val(@bind);
>>> }
>>>
>>
>> Doesn't select_val() return just one value?  Seem like in the case
>> above you would define a TEMP column 'Count' and then search as
>> normal with $class->search_summarize()
>>
>
> Thus the desire to understand what I'm coding :)
>
> Where is select_val documented?
>
> how would search_summarize get my where clause?  Or would I be able to
> pass it along?
>
> -- 
> SwiftOne  /  Brett Sanger
> swiftone at swiftone.org
>
> _______________________________________________
> ClassDBI mailing list
> ClassDBI at lists.digitalcraftsmen.net
> http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
>





More information about the ClassDBI mailing list