[ic] simple query problem

[Bill Carr]

On Jul 19, 2007, at 2:04 PM, mail wrote:

> 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?
There was just a post about not using "!=" but using "<>" as your  
inequality operator.

Bill Carr