[ic] simple query problem

mail 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:
> > 
> > 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
> 

OK, sorry. that was so simple, how could I have missed that?  I need to
take a break...

thanks!
rick




More information about the interchange-users mailing list