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