[Zope] Searching for a generalized key in ZSQL...

Donald Holten donner@biophysics.lanl.gov
Mon, 2 Aug 1999 11:50:04 -0600 (MDT)


	I've tried out the <!--#if searchkey in ['firstname','lastname',etc...]  
and it complains about the word "in", saying it isn't a legal argument.  I've 
also tried:
<!--#in ['firstname','lastname',etc...]-->
  <!--#if "searchkey == sequence-item"-->
    select *
      from Users
      where <!--#var searchkey--> = <!--#sqlvar searchvalue type=string-->
      order by <!--#var searchkey--> 
  <!--#/if-->
<!--#/in-->
	And that complains:
	Error, exceptions.KeyError:
['firstname','lastname',etc...] 

SQL used:

Could not render the query template!
	The list looks good, from my view, so I don't understand the key error.
	Donner