<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'><font style="font-size:10pt;" color="#366092" face="Arial" size="2"><br id="FontBreak"></font>Hello Michel and all the FS community,<br><br>I've noticed recently one thing about the GeoAlchemy operator "ilike" in FS R 1.15.1, it cannot be used with more than one word and blank spaces. For example, if I do:<br><br>fs/All_layers?format=GeoJSON&comments__ilike=<b>gery</b>&queryable=comments<br><br>I get the right results. However using this:<br><br>fs/All_layers?format=GeoJSON&comments__ilike=<b>gery thesis</b>&queryable=comments<br><br>I get nothing, ie., {"crs": null, "type": "FeatureCollection", "features": []}<br><br>what should I change in the Geoalchemy source code to get this working? could it be fixed in FS 2?<br><br>Cheers,<br><br>Gery<br><br><br><br><font style="font-size:10pt;" color="#1F497D" face="Arial" size="2">__________________________________________________________________________________________<br>Piensa en el medio ambie<font style="" face="Arial">nte - mantenlo en la pantalla. NO lo imprimas si NO es necesario.</font></font><font style="font-size:10pt;" color="#1F497D" face="Arial" size="2"><br></font><font style="font-size:10pt;" color="#1F497D" face="Arial" size="2">Think green - keep it on the screen. Do NOT print if it is NOT necessary.</font><font style="font-size:10pt;" color="#1F497D" face="Arial" size="2"><br></font><font style="font-size:10pt;" color="#1F497D" face="Arial" size="2"><span id="ecxresult_box" class="ecxshort_text" lang="de"><span class="ecxhps">Denken Sie an</span> <span class="ecxhps">die Umwelt</span></span></font><font style="font-size:10pt;" color="#1F497D" face="Arial" size="2"><span id="ecxresult_box" lang="de"><span class="ecxhps"></span> <span class="ecxhps">-</span> <span class="ecxhps">bewahren Sie es</span> <span class="ecxhps">auf dem Bildschirm.</span> <span class="ecxhps">Drucken Sie es NICHT</span><span>, wenn</span> <span class="ecxhps">es NICHT notwendig ist</span><span>.</span></span></font><br>                                     </div></body>
</html>