<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>Hi,<div><br></div><div><span style="font-size: 12pt;">Consider the following filter :</span></div><div><span style="font-size: 12pt;"><br></span></div><div><span style="font-size: 12pt;"><div> var f1 = new OpenLayers.Filter.Logical({</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> type: OpenLayers.Filter.Logical.AND,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> filters: [</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> new OpenLayers.Filter.Comparison({</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> type: OpenLayers.Filter.Comparison.EQUAL_TO,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> property: "rnummer ",</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> value: "<span style="font-size: 12pt;">1000578"</span></div></span><span style="font-size: 12pt;"><div><span class="Apple-tab-span" style="white-space:pre"> </span> }),</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> new OpenLayers.Filter.Comparison({</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> type: OpenLayers.Filter.Comparison.EQUAL_TO,</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> property: "rnummer ",</div><div><span class="Apple-tab-span" style="white-space:pre"> </span> value: "<span style="font-size: 12pt;">100546"</span></div></span><span style="font-size: 12pt;"><div><span class="Apple-tab-span" style="white-space:pre"> </span> })]</div><div> });</div></span></div><div><br></div><div>This will return all rows where the property 'rnummer' equals '<span style="font-size: 12pt;">1000578' or '</span><span style="font-size: 12pt;">100546'. I don't know in advance how many rnummers I have, so I am looking for a way to get openLayers to invoke a SQL-'IN' statement </span><span style="font-size: 12pt;">Can I do this or are there better ways to achieve what I want ?</span></div><div><span style="font-size: 12pt;"><br></span></div><div><span style="font-size: 12pt;">thanks, Stephan</span></div> </div></body>
</html>