[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