Hi Stephan, <div><br></div><div>With  <span style="font-family:Verdana,Arial,sans-serif;font-size:13px;background-color:rgb(255,255,255)">OpenLayers.Filter.Comparison.BETWEEN operator ,</span></div><div><font face="Verdana, Arial, sans-serif">if you know the min</font><span style="font-family:Verdana,Arial,sans-serif">(rnummer)</span><span style="font-family:Verdana,Arial,sans-serif"> and max(rnummer) I think you can use it instead of EQUAL_TO.</span></div>

<div><br></div><div><div>regards,<br>-<br>Vivek M. Chaure<br><div><font color="#999999">M.Tech.(CS), IIT Kharagpur.</font></div><div><div><b style="color:rgb(153,153,153)"><br></b></div></div></div>
<br><br><div class="gmail_quote">On Mon, May 13, 2013 at 3:23 PM, Stephan Deckers <span dir="ltr"><<a href="mailto:stephandeckers@hotmail.com" target="_blank">stephandeckers@hotmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">




<div><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 style="white-space:pre-wrap">  </span>                type: OpenLayers.Filter.Logical.AND,</div><div><span style="white-space:pre-wrap">     </span>                filters: [</div><div><span style="white-space:pre-wrap">       </span>                    new OpenLayers.Filter.Comparison({</div>

<div><span style="white-space:pre-wrap">          </span>                type: OpenLayers.Filter.Comparison.EQUAL_TO,</div><div><span style="white-space:pre-wrap">             </span>                property: "rnummer ",</div><div>

<span style="white-space:pre-wrap">             </span>                value: "<span style="font-size:12pt">1000578"</span></div></span><span style="font-size:12pt"><div><span style="white-space:pre-wrap">   </span>                    }),</div>

<div><span style="white-space:pre-wrap">  </span>                    new OpenLayers.Filter.Comparison({</div><div><span style="white-space:pre-wrap">           </span>                type: OpenLayers.Filter.Comparison.EQUAL_TO,</div>

<div><span style="white-space:pre-wrap">          </span>                property: "rnummer ",</div><div><span style="white-space:pre-wrap">          </span>                value: "<span style="font-size:12pt">100546"</span></div>

</span><span style="font-size:12pt"><div><span style="white-space:pre-wrap">        </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></div>
<br>_______________________________________________<br>
Users mailing list<br>
<a href="mailto:Users@lists.osgeo.org">Users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/openlayers-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/openlayers-users</a><br>
<br></blockquote></div><br></div>