Re: count_search_where deleting its parameters ?

[prev] [thread] [next] [Date index for 2005/01/08]

>>>>> "Gabor" == Gabor Szabo <gabor@xxxx.xxx.xx> writes:

Gabor>     age <= 80 AND age >= 20 AND city = Jerusalem

Gabor> In SQL::Abstract I can do this by
Gabor> $sql = SQL::Abstract->new(logic => 'and');

Gabor> print $sql->where([
Gabor>      age  => {'<=', 80},
Gabor>      age  => {'=>', 20},
Gabor>      city => 'Jerusalem',
Gabor>      ]), "\n";

I solved this by using a hash with funny keys:

where({
  age => {'>=', 20},
  ' age' => {'<=', 80},
  city => 'Jerusalem',
});

Yeah, it's hacky, but it works fine.

        -- 
        Randal L. Schwartz - Stonehenge Consulting Services, Inc. - +1 503 777 0095
<merlyn@xxxxxxxxxx.xxx> <URL:http://www.stonehenge.com/merlyn/>
Perl/Unix/security consulting, Technical writing, Comedy, etc. etc.
See PerlTraining.Stonehenge.com for onsite and open-enrollment Perl training!