I have a ZSQL query getPlayersBySeasons with one input value, seasonID:
select distinct player.playerID, firstName, lastName, number, birthdate,
positions, bats, throws, active
from player, SeasonPlayer
<dtml-sqlgroup required where>
<dtml-sqltest seasonID column=SeasonPlayer.seasonID type=int optional
and my python code:
players = context.getPlayersBySeasons(seasonID=s).dictionaries()
If s = , or s=, or s=[1,2] or s="", I get the same result set back.
What is the correct syntax for using the multiple key word? I have googled
and it seems that a lot of people have problems, and no one has a solution.
Zope-DB mailing list