[Zope] Using lists in DTML

Christopher J. Kucera ckucera@globalcrossing.com
Wed, 05 Apr 2000 15:44:17 -0500


Ken Kinder wrote:
> 
> I'm using Oracle flavor SQL. Can I use that SQL on more than two? This
> will eventually be three queries.

Yes.  For efficiency's sake, though, you'd probably want to see if you
could just combine them into a single statement:

  select distinct whatever from table where first='foo' or second='bar'
         or third='baz' . . .

This would probably be a much better solution if it's possible with
the queries you're using.

-CJ