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