[ic] simple query problem
mail
lists at gmnet.net
Thu Jul 19 14:04:19 EDT 2007
Hi,
I seem to have a problem with my [query] tag
here is is:
[query
type=list
label=leftmenu
prefix=collections
list_prefix=collections_list
table=collections
ml=none
sql=|
SELECT * FROM `collections`
WHERE `prod_group` = Jewelry
AND `pending` != 1
AND `nla` != 1
AND `inactive` != 1
|]
and here is my error log:
216.114.142.43 N282FRxe:duprat duprat [19/July/2007:13:56:55 -0400]
dd /cgi/dd/jewelry.html Query on table `collections` failed: Can't call
method "config" on an undefined value
at /usr/local/interchange-5.4.2/lib/Vend/Table/DBI.pm line 1987.
>
> Query was: SELECT * FROM `collections`
> WHERE `prod_group` = Jewelry
> AND `pending` != 1
> AND `nla` != 1
> AND `inactive` != 1
It was a [search-region] and it worked fine, however, I need to use it
on my results page, and so I changed it from a search-region to a
query.
Does anybody know what the problem might be?
thanks
rick
More information about the interchange-users
mailing list