Re: search() without search criteria

[prev] [thread] [next] [Date index for 2005/04/29]

From: Peter Speltz
Subject: Re: search() without search criteria
Date: 19:11 on 29 Apr 2005

--- Tony Bowden <tony-cdbitalk@xxxxx.xxx> wrote:
> On Fri, Apr 29, 2005 at 05:53:00PM +0100, Will Hawes wrote:
> > A patch to search() (or rather, _do_search()) would be a better
> > solution. The ability to pass an empty hash to search() is logical and
> 
> Why? 
> 
> Surely a search with no search criteria is no longer a search?
> 

I think it is a search. In SQL  what is a "search" ?  Is it a SELECT  plus a  a
WHERE clause?  Does a search without any criteria give back 0 rows, all rows,
or die of SQL syntax error? Often users get a listing when they search with no
criteria.   Maypole's default search page  does a retrieve all if no criteria
and a search_where if there is criteria.  I think this makes sense from a
user's point of view as they may not know any criteria until they see a
listing. 

Programattically what Will suggests can make coding easier. I think search
funciton without any criteria should do a "Select __ESSENTIAL__ from __TABLE";

pjs

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com