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 _______________________________________________ interchange-users mailing list suppressed http://www.icdevgroup.org/mailman/listinfo/interchange-users
Mail converted by mhonarc 2.6.15
This archive provided courtesy of JSW4.NET, Internet Hosting Services for Small Business.