[Zope] sql like functionality to query zcatalogs

Joel Jensen joel at joeljensen.com
Fri Apr 16 10:47:16 EDT 2004


Hi all,

This one has been nagging me.

Is there some way to search a zcatalogs indexes using SQL?

I have a few thousand objects that have price scattered throughout a 
site I am building.
I am looking the price up in a MySQL database based on the objects id.

I am seeking a way of cataloging all the objects ( done ) and search 
that catalog for objects with prices between a certain range.

For example:
select * from zcatalog where price > 2.5 and price < 2.75

If not sql, which way would be the most simple to do this?

Thanks in advance

Joel Jensen.



More information about the Zope mailing list