[ic] Form seach on other tables than Products
Kevin Walsh
kevin at cursor.biz
Sun Nov 19 17:01:26 EST 2006
"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
_/ _/ _/_/_/_/ _/ _/_/_/ _/ _/
More information about the interchange-users
mailing list