[ic] simple query problem
Bill Carr
bill at worldwideimpact.com
Thu Jul 19 14:37:35 EDT 2007
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
More information about the interchange-users
mailing list