[ic] simple query problem
Stefan Hornburg (Racke)
racke at linuxia.de
Thu Jul 19 14:16:31 EDT 2007
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?
Bad SQL query, quote Jewelry.
Regards
Racke
--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team
More information about the interchange-users
mailing list