[Zope] Re: Catalog Anything Problem

[Bobby Mathew]

THANKS GUYS
It worked once i changed the case...
Once again you guys are genius's
thanks a lot

bobby
----- Original Message -----
From: Ron Bickers <rbickers@logicetc.com>
To: <cduncan@kaivo.com>; Bobby Mathew <bobby@dialognet.com>
Cc: <zope@zope.org>
Sent: Thursday, May 03, 2001 8:02 PM
Subject: RE: [Zope] Re: Catalog Anything Problem


>
> > > Firstly i created a new catalog called prods under
> > /learn/search/ and did
> > > nothing further
> > > secondly i kept the zsql method outside under the path /learn/search/
> > > called it getProdtoCatalog()
>
> I may have misled you as far as where to put the ZSQL Method.  It's okay
to
> have the method in the contents part of the catalog where the Python
Script
> is, you just don't want to use the 'Find Objects' to add it to the
catalog's
> search index.  Of course, with acquisition, it works all the same where
you
> put it.
>
> > Try Product.number, Databases often return field names in all lower case
> > regardless of the case specified in the SQL.
>
> I can't think of any reason for the error, but this sounds like a good
thing
> to try.  MySQL is case sensitive so I've always stuck to the case as
defined
> in the table.  If changing the case works, let me know.
> _______________________
>
> Ron Bickers
> Logic Etc, Inc.
> rbickers@logicetc.com
>