[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