<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi again,<br><br>I'm reading better your previous email and I see that the solution is already there only a "'" was missing :-)<br><br>so the good format is <br><br>EXPRESSION ('[id]' IN '%shoplist%') <br><br>Thank you very much<br><br>Valerio<br><br>--- <b>Ven 29/8/08, valerio vianello <i><valerio.vianello@yahoo.it></i></b> ha scritto:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">Da: valerio vianello <valerio.vianello@yahoo.it><br>Oggetto: Re: [mapserver-users] show only some point on the map<br>A: adams@terrestris.de, "Steve Lime" <Steve.Lime@dnr.state.mn.us><br>Cc: mapserver-users@lists.osgeo.org<br>Data: Venerdì 29 agosto 2008, 08:33<br><br><div id="yiv1647665320"><table border="0" cellpadding="0" cellspacing="0"><tbody><tr><td style="font-family: inherit; font-style: inherit;
font-variant: inherit; font-weight: inherit; font-size: inherit; line-height: inherit; font-size-adjust: inherit; font-stretch: inherit; -x-system-font: none;" valign="top">Hi Steve,<br><br>I have still some problem,<br><br>my setting is the follow<br><br>CLASSITEM 'id'<br><br>and then into the CLASS<br><br>EXPRESSION ('id' IN '%listid%' )<br><br>where id is the value in the shapefile and listid is the parameter that I pass to the cgi as a comma separated value.<br><br>What's wrong ?<br><br>Thanks<br>Valerio<br><br>--- <b>Gio 28/8/08, Steve Lime <i><Steve.Lime@dnr.state.mn.us></i></b> ha scritto:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;">Da: Steve Lime <Steve.Lime@dnr.state.mn.us><br>Oggetto: Re: [mapserver-users] show only some point on the map<br>A: adams@terrestris.de, valerio.vianello@yahoo.it<br>Cc: mapserver-users@lists.osgeo.org<br>Data: Giovedì 28 agosto 2008,
16:27<br><br><pre>The IN operator works with all datasources since it's an<br> expression.<br>I've done this before and it works fine although there are probably some<br>practical limits in the number of features you'd want to deal with this<br>way. If you can group the IDs into one var (e.g ids) and then use an<br>expression like:<br><br> EXRESSION ('[myid] in '%ids')<br><br>That should work...<br><br>Steve<br><br>>>> valerio vianello <valerio.vianello@yahoo.it> 08/28/08 5:16<br>AM >>><br>Hi Till,<br><br>maybe I forgot to tell you that my data source is a shapefile and not a<br>database.<br><br>so if I have good understood the only solution that I have to try is to<br>use an SLD file.<br><br>Regards to group the point in such a way in not possible in this case<br>becouse I have a certain number of points and in each request the user<br>should be able to select the point to show.<br><br>br,<br>Valerio.<br><br>--- Gio 28/8/08,
Till Adams <adams@terrestris.de> ha scritto:<br>Da: Till Adams<br> <adams@terrestris.de><br>Oggetto: Re: [mapserver-users] show only some point on the map<br>A: valerio.vianello@yahoo.it<br>Cc: "mapserver" <mapserver-users@lists.osgeo.org><br>Data: Giovedì 28 agosto 2008, 10:41<br><br>valerio,<br><br>OK, I think you may use more than one subvar, but if there are too many,<br>...<br><br>And there is no way to group the points together in any attribute, which<br><br>are shown together?<br><br>One solution might be to generate a temporary view in a database (if the<br><br>points come out of such) and then<br>send the name of the view via subvar to your file.<br><br>Even better, generate a string out of your selected gid's like<br><br>1,3,45,567,789,790<br><br>Send this Stringvia subvar to your mapfile and use a "WHERE gid IN ('<br><br>YOURSTRING ') in your SQL in the mapfile...<br><br><br>Another possible solution might be...hack around
and not really fine, <br>but write a temporary SLD file - which only<br> works when using mapserver <br>as WMS server.<br>You can let a script write a temporary-SLD file, where your filter is <br>set to your ids and apply this to your getmap request <br>(&SLD=path/tp/your_name.xml).<br><br>To ensure, that only user A uses his filtered SLD, we normally used the <br>PHP session ID or sth similar for naming the sld.<br><br>Many ideas, find the best way for you...<br>Regards, Till<br><br>> Dear Till,<br>><br>> Thanks for the suggestion.<br>><br>> But with variable substitution I am able to specify only one parameter<br><br>> like<br>><br>> EXPRESSION ([FNR]=%myid%) .<br>><br>> in this case on the map will be shown only one point (if myid is <br>> unique) or a group of points (if myid is shared among them)<br>><br>> in my case I want show the points with myid1,myid2,myid3...<br>><br>> how I should set this
into the mapfile ?<br>><br>> regards<br>><br>> Valerio<br>><br> --- *Gio 28/8/08, Till Adams /<adams@terrestris.de>/* ha scritto:<br>><br>> Da: Till Adams <adams@terrestris.de><br>> Oggetto: Re: [mapserver-users] show only some point on the map<br>> A: valerio.vianello@yahoo.it<br>> Cc: "mapserver" <mapserver-users@lists.osgeo.org><br>> Data: Giovedì 28 agosto 2008, 09:35<br>><br>> Dear Valerio,<br>><br>> I guess what you need is this:<br>> http://mapserver.gis.umn.edu/docs/reference/mapfile/variable_sub<br>><br>> So add a variable substitution and insert it into your expression<br>in<br>the <br>> CALL section of your layer.<br>><br>> Regards,<br>> Till<br>> > Dear list,<br>> ><br>> > I have this question:<br>> ><br>> > I have a map file in which there is a POINT layer
that uses a <br>> > shapefile as datasource. Is possible with mapserver<br> to do a<br>request to <br>> > show only some point on the map ?<br>> ><br>> > I know that i can show a group of points or only one point using<br><br>> > FILTER and CLASSITEM into the map file but my goal is a bit<br>different. <br>> > In my case each poi has an ID into the shapefile, and I want<br>make<br>a <br>> > request to serve the follow question:<br>> ><br>> > Show on map the poi with ID 3,6,8.<br>> ><br>> > any suggetsion ?<br>> ><br>> > P.S I'm using CGI interface maybe is this possible to do with<br>> mapscript ?<br>> ><br>> > thanks everybady<br>> ><br>> > Valerio<br>> ><br>> ><br>> > > Poco spazio e tanto spam? Yahoo! Mail ti protegge dallo<br>spam
e<br>ti<br>da <br>> ><br>> tanto spazio gratuito per i tuoi file e i<br> messaggi<br>> > http://mail.yahoo.it<br>> ><br>------------------------------------------------------------------------<br>> ><br>> > _______________________________________________<br>> > mapserver-users mailing list<br>> > mapserver-users@lists.osgeo.org<br>> > http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>> > <br>><br>><br>> -- <br>> ----------------------------------------------------------<br>> terrestris GmbH & Co. KG<br>> Irmintrudisstrasse 17<br>> 53111 Bonn<br>> Germany<br>><br>> Till Adams<br>> Geschäftsführung<br>><br>> Tel: +49 (0)228 / 962 899-52<br>> Fax: +49 (0)228 / 962 899-57<br>> adams@terrestris.de http://www.terrestris.de<br>> Amtsgericht Bonn, HRA
6835<br>> ---------------------------------------------------------<br>><br>> <br> Komplementärin:<br>><br>> terrestris Verwaltungs GmbH<br>><br>> vertreten durch:<br>> Hinrich Paulsen, Till<br>> Adams<br>><br>> <br>><br>><br>> __________________________________________________<br>> Do You Yahoo!?<br>> Poco spazio e tanto spam? Yahoo! Mail ti protegge dallo spam e ti da <br>> tanto spazio gratuito per i tuoi file e i messaggi<br>> http://mail.yahoo.it <br><br><br>-- <br>----------------------------------------------------------<br>terrestris GmbH & Co. KG<br>Irmintrudisstrasse 17<br>53111 Bonn<br>Germany<br><br>Till Adams<br>Geschäftsführung<br><br>Tel: +49 (0)228 / 962 899-52<br>Fax: +49 (0)228 / 962 899-57<br>adams@terrestris.de http://www.terrestris.de<br>Amtsgericht Bonn, HRA
6835<br>---------------------------------------------------------<br><br>Komplementärin:<br><br>terrestris Verwaltungs GmbH<br><br>vertreten durch:<br>Hinrich Paulsen, Till<br> Adams<br><br><br><br>__________________________________________________<br>Do You Yahoo!?<br>Poco spazio e tanto spam? Yahoo! Mail ti protegge dallo spam e ti da<br>tanto spazio gratuito per i tuoi file e i messaggi <br>http://mail.yahoo.it <br></pre></blockquote></td></tr></tbody></table><br>__________________________________________________<br>Do You Yahoo!?<br>Poco spazio e tanto spam? Yahoo! Mail ti protegge dallo spam e ti da tanto spazio gratuito per i tuoi file e i messaggi <br>http://mail.yahoo.it </div><pre>_______________________________________________<br>mapserver-users mailing
list<br>mapserver-users@lists.osgeo.org<br>http://lists.osgeo.org/mailman/listinfo/mapserver-users<br></pre></blockquote></td></tr></table><br>__________________________________________________<br>Do You Yahoo!?<br>Poco spazio e tanto spam? Yahoo! Mail ti protegge dallo spam e ti da tanto spazio gratuito per i tuoi file e i messaggi <br>http://mail.yahoo.it