Re: [mapserver-users] RE Dynamically extent and layer filter
In your mapfile you could set FILTER id in (%ID%) . And in the url pass a string as parameter such as id=1,4,8 That would be a simple way Please post further question on mapserver list, so others can answer you, and the answers can help other people later thanks steve Dedy Fuadi sampahe@gmail.com 2014-05-30 11:28 A steve.tout...@inspq.qc.ca cc Objet Re: RE [mapserver-users] Dynamically extent and layer filter Hi Steve, Your advice is nicely work for me! :D But how to select more than one data from postgis by VALIDATION block? For example, I have a postgis table that have 20 data, then I wanto to select data 1,4,8, or else to display by customizing URL parameter. I set '%id%' as my variable at mapfile, I just can display one data like id=1. Please for your help. Thank you. On Fri, May 30, 2014 at 8:30 PM, steve.tout...@inspq.qc.ca wrote: Hi What did you try and what happened? Something in the mapserver log. If I understand well you want to use run time substitution, if so here a link http://mapserver.org/cgi/runsub.html Make sure you have a VALIDATION block Steve Dedy Fuadi sampahe@gmail.com@lists.osgeo.org Envoyé par : mapserver-users-boun...@lists.osgeo.org 2014-05-30 06:52 A mapserver-users@lists.osgeo.org cc Objet [mapserver-users] Dynamically extent and layer filter Hello friends, I just success applying filter data for postgis database on my mapfile, but I met problem when I was to try use dynamic variable for filter data and extent map like variable at php file. What should I do for solving this problem? Whether mapfile can be a dynamically file like php? Thank you, regards.___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] RE Dynamically extent and layer filter
This is my mapfile part : VALIDATION 'id' '^[0-9]{1}$' END FILTER (id in ('%id%')) and as your advice I set URL parameter like id=1,4,8 but the map is not appears there. When I opened debug, I found : [Sat May 31 00:10:34 2014].758000 msEvalRegex(): Regular expression error. String failed expression test. [Sat May 31 00:10:34 2014].758000 loadForm(): Web application error. Parameter 'id' value fails to validate. On Fri, May 30, 2014 at 11:42 PM, steve.tout...@inspq.qc.ca wrote: In your mapfile you could set FILTER id in (%ID%) . And in the url pass a string as parameter such as id=1,4,8 That would be a simple way Please post further question on mapserver list, so others can answer you, and the answers can help other people later thanks steve *Dedy Fuadi sampahe@gmail.com sampahe@gmail.com* 2014-05-30 11:28 A steve.tout...@inspq.qc.ca cc Objet Re: RE [mapserver-users] Dynamically extent and layer filter Hi Steve, Your advice is nicely work for me! :D But how to select more than one data from postgis by VALIDATION block? For example, I have a postgis table that have 20 data, then I wanto to select data 1,4,8, or else to display by customizing URL parameter. I set '%id%' as my variable at mapfile, I just can display one data like id=1. Please for your help. Thank you. On Fri, May 30, 2014 at 8:30 PM, *steve.tout...@inspq.qc.ca* steve.tout...@inspq.qc.ca wrote: Hi What did you try and what happened? Something in the mapserver log. If I understand well you want to use run time substitution, if so here a link *http://mapserver.org/cgi/runsub.html* http://mapserver.org/cgi/runsub.html Make sure you have a VALIDATION block Steve *Dedy Fuadi **sampahe@gmail.com* sampahe@gmail.com*@* *lists.osgeo.org* http://lists.osgeo.org/ Envoyé par : *mapserver-users-boun...@lists.osgeo.org* mapserver-users-boun...@lists.osgeo.org 2014-05-30 06:52 A *mapserver-users@lists.osgeo.org* mapserver-users@lists.osgeo.org cc Objet [mapserver-users] Dynamically extent and layer filter Hello friends, I just success applying filter data for postgis database on my mapfile, but I met problem when I was to try use dynamic variable for filter data and extent map like variable at php file. What should I do for solving this problem? Whether mapfile can be a dynamically file like php? Thank you, regards.___ mapserver-users mailing list *mapserver-users@lists.osgeo.org* mapserver-users@lists.osgeo.org *http://lists.osgeo.org/mailman/listinfo/mapserver-users* http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] RE Dynamically extent and layer filter
Begin with a simple validation until it works. Is it working if you set VALIDATION id '.*' END If yes then the problem is in your regex. Make sure that ',' are accepted. If not the problem is the FILTER or the parameter you pass. Also Is your ID an integer or text in postgis? I think it matters. ('%id%') this would send a string to pg. In this case try FILTER id in ('%id%'), otherwise try FILTER id in (%id%) It is not an easy task (in my opinion) in mapserv to use expresion and filter But have a look at this. there are several examples http://mapserver.org/fr/mapfile/expressions.html#string-expressions-that-return-a-logical-value Also in you MAPFILE set debug 5 in the MAP block, and also in your layer block. You will have more info in your mapserver log. steve Dedy Fuadi sampahe@gmail.com 2014-05-30 12:17 A steve.tout...@inspq.qc.ca cc mapserver-users@lists.osgeo.org Objet Re: RE [mapserver-users] Dynamically extent and layer filter This is my mapfile part : VALIDATION 'id' '^[0-9]{1}$' END FILTER (id in ('%id%')) and as your advice I set URL parameter like id=1,4,8 but the map is not appears there. When I opened debug, I found : [Sat May 31 00:10:34 2014].758000 msEvalRegex(): Regular expression error. String failed expression test. [Sat May 31 00:10:34 2014].758000 loadForm(): Web application error. Parameter 'id' value fails to validate. On Fri, May 30, 2014 at 11:42 PM, steve.tout...@inspq.qc.ca wrote: In your mapfile you could set FILTER id in (%ID%) . And in the url pass a string as parameter such as id=1,4,8 That would be a simple way Please post further question on mapserver list, so others can answer you, and the answers can help other people later thanks steve Dedy Fuadi sampahe@gmail.com 2014-05-30 11:28 A steve.tout...@inspq.qc.ca cc Objet Re: RE [mapserver-users] Dynamically extent and layer filter Hi Steve, Your advice is nicely work for me! :D But how to select more than one data from postgis by VALIDATION block? For example, I have a postgis table that have 20 data, then I wanto to select data 1,4,8, or else to display by customizing URL parameter. I set '%id%' as my variable at mapfile, I just can display one data like id=1. Please for your help. Thank you. On Fri, May 30, 2014 at 8:30 PM, steve.tout...@inspq.qc.ca wrote: Hi What did you try and what happened? Something in the mapserver log. If I understand well you want to use run time substitution, if so here a link http://mapserver.org/cgi/runsub.html Make sure you have a VALIDATION block Steve Dedy Fuadi sampahe@gmail.com@lists.osgeo.org Envoyé par : mapserver-users-boun...@lists.osgeo.org 2014-05-30 06:52 A mapserver-users@lists.osgeo.org cc Objet [mapserver-users] Dynamically extent and layer filter Hello friends, I just success applying filter data for postgis database on my mapfile, but I met problem when I was to try use dynamic variable for filter data and extent map like variable at php file. What should I do for solving this problem? Whether mapfile can be a dynamically file like php? Thank you, regards.___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] RE Dynamically extent and layer filter
Wow! Thank you very much Steven! Finally I can display custom data from postgis with your links before. I set like this for the mapfile : VALIDATION 'tid' '^[0-9]{1}\,' END FILTER (id in (%tid%)) And this is nicely work for me. :D Thank you, regards. On Sat, May 31, 2014 at 12:30 AM, steve.tout...@inspq.qc.ca wrote: Begin with a simple validation until it works. Is it working if you set VALIDATION id '.*' END If yes then the problem is in your regex. Make sure that ',' are accepted. If not the problem is the FILTER or the parameter you pass. Also Is your ID an integer or text in postgis? I think it matters. ('%id%') this would send a string to pg. In this case try FILTER id in ('%id%'), otherwise try FILTER id in (%id%) It is not an easy task (in my opinion) in mapserv to use expresion and filter But have a look at this. there are several examples http://mapserver.org/fr/mapfile/expressions.html#string-expressions-that-return-a-logical-value Also in you MAPFILE set debug 5 in the MAP block, and also in your layer block. You will have more info in your mapserver log. steve *Dedy Fuadi sampahe@gmail.com sampahe@gmail.com* 2014-05-30 12:17 A steve.tout...@inspq.qc.ca cc mapserver-users@lists.osgeo.org Objet Re: RE [mapserver-users] Dynamically extent and layer filter This is my mapfile part : VALIDATION 'id' '^[0-9]{1}$' END FILTER (id in ('%id%')) and as your advice I set URL parameter like id=1,4,8 but the map is not appears there. When I opened debug, I found : [Sat May 31 00:10:34 2014].758000 msEvalRegex(): Regular expression error. String failed expression test. [Sat May 31 00:10:34 2014].758000 loadForm(): Web application error. Parameter 'id' value fails to validate. On Fri, May 30, 2014 at 11:42 PM, *steve.tout...@inspq.qc.ca* steve.tout...@inspq.qc.ca wrote: In your mapfile you could set FILTER id in (%ID%) . And in the url pass a string as parameter such as id=1,4,8 That would be a simple way Please post further question on mapserver list, so others can answer you, and the answers can help other people later thanks steve *Dedy Fuadi **sampahe@gmail.com* sampahe@gmail.com** 2014-05-30 11:28 A *steve.tout...@inspq.qc.ca* steve.tout...@inspq.qc.ca cc Objet Re: RE [mapserver-users] Dynamically extent and layer filter Hi Steve, Your advice is nicely work for me! :D But how to select more than one data from postgis by VALIDATION block? For example, I have a postgis table that have 20 data, then I wanto to select data 1,4,8, or else to display by customizing URL parameter. I set '%id%' as my variable at mapfile, I just can display one data like id=1. Please for your help. Thank you. On Fri, May 30, 2014 at 8:30 PM, *steve.tout...@inspq.qc.ca* steve.tout...@inspq.qc.ca wrote: Hi What did you try and what happened? Something in the mapserver log. If I understand well you want to use run time substitution, if so here a link *http://mapserver.org/cgi/runsub.html* http://mapserver.org/cgi/runsub.html Make sure you have a VALIDATION block Steve *Dedy Fuadi **sampahe@gmail.com* sampahe@gmail.com*@* *lists.osgeo.org* http://lists.osgeo.org/ Envoyé par : *mapserver-users-boun...@lists.osgeo.org* mapserver-users-boun...@lists.osgeo.org 2014-05-30 06:52 A *mapserver-users@lists.osgeo.org* mapserver-users@lists.osgeo.org cc Objet [mapserver-users] Dynamically extent and layer filter Hello friends, I just success applying filter data for postgis database on my mapfile, but I met problem when I was to try use dynamic variable for filter data and extent map like variable at php file. What should I do for solving this problem? Whether mapfile can be a dynamically file like php? Thank you, regards.___ mapserver-users mailing list *mapserver-users@lists.osgeo.org* mapserver-users@lists.osgeo.org *http://lists.osgeo.org/mailman/listinfo/mapserver-users* http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users