Hi all,<br>I get the plugin <a href="http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070619/68173e58/filterPlugin.zip">filterPlugin</a> written by Dirk Jesko (<a href="http://lists.maptools.org/pipermail/cartoweb-users/2007-June/002574.html">there is a year</a>). I'm trying to change the code so that it would be possible to filter according to several parameters ($filterString) by layer.<br>
<br>I must have in my serverFilter<br><br>$ layer-> data = "the_geom FROM (SELECT * FROM table WHERE column1 = {$filterString1} AND column2 = {$filterString2} ....)". "Foo USING UNIQUE AS gid USING SRID =- 1";<br>
<br>instead:<br><br>$ layer-> data = "the_geom FROM (SELECT * FROM table WHERE column1 = {$filterString1})". "Foo USING UNIQUE gid USING SRID =- 1";<br><br><br>help please...<br><br><br><span style="color: rgb(102, 0, 0);">En français :</span><br style="color: rgb(102, 0, 0);">
<br style="color: rgb(102, 0, 0);"><span style="color: rgb(102, 0, 0);">Salut tout le monde,</span><br style="color: rgb(102, 0, 0);"><span style="color: rgb(102, 0, 0);">J'ai récupéré le plugin filterPlugin </span><a style="color: rgb(102, 0, 0);" href="http://lists.maptools.org/pipermail/cartoweb-users/attachments/20070619/68173e58/filterPlugin.zip">ici</a><span style="color: rgb(102, 0, 0);"> écrit par Dirk Jesko (</span><a style="color: rgb(102, 0, 0);" href="http://lists.maptools.org/pipermail/cartoweb-users/2007-June/002574.html">il ya un an</a><span style="color: rgb(102, 0, 0);">). J'essaye depuis un moment de modifier le code de sorte qu'il serait possible de filtrer les données selon plusieurs paramètres ($filterString).</span><br style="color: rgb(102, 0, 0);">
<br style="color: rgb(102, 0, 0);"><span style="color: rgb(102, 0, 0);">Je dois avoir dans mon serverFilter</span><br style="color: rgb(102, 0, 0);"><br style="color: rgb(102, 0, 0);"><span style="color: rgb(102, 0, 0);">$ layer-> data = "the_geom FROM (SELECT * FROM table WHERE column1 =
{$filterString1} AND column2 = {$filterString2} ....)". "Foo USING
UNIQUE AS gid USING SRID =- 1";</span><br style="color: rgb(102, 0, 0);"><br style="color: rgb(102, 0, 0);"><span style="color: rgb(102, 0, 0);">au lieu de :</span><br style="color: rgb(102, 0, 0);"><br style="color: rgb(102, 0, 0);">
<span style="color: rgb(102, 0, 0);">$ layer-> data = "the_geom FROM (SELECT * FROM table WHERE column1 =
{$filterString1})". "Foo USING UNIQUE gid USING SRID =- 1";</span><br style="color: rgb(102, 0, 0);">
<br style="color: rgb(102, 0, 0);"><span style="color: rgb(102, 0, 0);">Merci de votre aide...</span><br>