[ic] simple query problem
lists at gmnet.net
Thu Jul 19 14:33:21 EDT 2007
On Thu, 2007-07-19 at 20:16 +0200, Stefan Hornburg (Racke) wrote:
> 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:
> > 18.104.22.168 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.
OK, sorry. that was so simple, how could I have missed that? I need to
take a break...
More information about the interchange-users