[ic] Form seach on other tables than Products

[Kevin Walsh]

"N.E.S.T. Solutions" <nest_consulting at yahoo.ca> wrote:
> The problem seems to be when I use 
> form action="[area search]" with fi=distributors table, it gives me 
> this error, even though I specify another table which doesn't 
> have an "inactive" column:
> 
> DBD::mysql::st execute failed: Unknown
> column 'inactive' in 'where clause' at
> /usr/local/spitfire-stores/lib/Vend/Table/DBI.pm line 1849.
> 
I suspect that you probably have the following somewhere in your
configuration:

    Database  distributors  HIDE_FIELD   inactive

If you don't have an "inactive" column then the error message would seem
reasonable.

You probably copied the "products" Database directives to create a new
"distributors" table definition, and didn't remove the HIDE_FIELD.

-- 
   _/   _/  _/_/_/_/  _/    _/  _/_/_/  _/    _/
  _/_/_/   _/_/      _/    _/    _/    _/_/  _/   K e v i n   W a l s h
 _/ _/    _/          _/ _/     _/    _/  _/_/    kevin at cursor.biz
_/   _/  _/_/_/_/      _/    _/_/_/  _/    _/