I have a ZSQL query getPlayersBySeasons with one input value, seasonID:<br><br>select distinct player.playerID, firstName, lastName, number, birthdate, positions, bats, throws, active<br>from player, SeasonPlayer<br><dtml-sqlgroup required where><br>
<dtml-sqltest seasonID column=SeasonPlayer.seasonID type=int optional multiple> <br> <dtml-and><br> SeasonPlayer.playerID=player.playerID<br></dtml-sqlgroup><br><br>and my python code:<br>players = context.getPlayersBySeasons(seasonID=s).dictionaries()<br>
<br>If s = [1], or s=[2], or s=[1,2] or s="", I get the same result set back.<br><br>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.<br>
<br>Thanks!<br><br>Mark<br>