[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