[Zope] ZCatalog: searching where on index == another index

2005-10-21 Thread Etienne Labuschagne
Hi all, Is there a way to search for all the records where one indexed field equals another indexed field? Equivalent SQL query would be: SELECT * FROM table WHERE field1 = field2 I know I can get all the unique values for field1 and then do a search for records where field2 = [unique field1

Re: [Zope] ZCatalog: searching where on index == another index

2005-10-21 Thread Andreas Jung
--On 21. Oktober 2005 13:00:35 +0200 Etienne Labuschagne [EMAIL PROTECTED] wrote: Hi all, Is there a way to search for all the records where one indexed field equals another indexed field? no. -aj pgpT5FL2z86QW.pgp Description: PGP signature

Re: [Zope] ZCatalog: searching where on index == another index

2005-10-21 Thread Dieter Maurer
Etienne Labuschagne wrote at 2005-10-21 13:00 +0200: Is there a way to search for all the records where one indexed field equals another indexed field? Equivalent SQL query would be: SELECT * FROM table WHERE field1 = field2 If the index has only a few different values, enumerating them may be