Re: [CDBI] Group by and AbstractSearch

[prev] [thread] [next] [Date index for 2005/10/21]

From: yoorobot
Subject: Re: [CDBI] Group by and AbstractSearch
Date: 16:01 on 21 Oct 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@xxxxxxxx.xxx
>
> _______________________________________________
> ClassDBI mailing list
> ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
> http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi
>


_______________________________________________
ClassDBI mailing list
ClassDBI@xxxxx.xxxxxxxxxxxxxxxx.xxx
http://lists.digitalcraftsmen.net/mailman/listinfo/classdbi

[CDBI] Group by and AbstractSearch
Brett Sanger 13:53 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
Bill Moseley 14:48 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
Brett Sanger 15:42 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
Dave Howorth 15:59 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
yoorobot 16:01 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
Brett Sanger 16:10 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
Michael Peters 16:19 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
Matt S Trout 16:34 on 21 Oct 2005

Re: [CDBI] Group by and AbstractSearch
Bill Moseley 18:20 on 21 Oct 2005

Generated at 19:52 on 24 Oct 2005 by mariachi v0.52