On Fri, May 27, 2011 at 12:13 PM, hassane <[email protected]> wrote: > Hi, > > > i would like to create an parametric SQL View in geoserver 2.1.0. but the > parameter is the name of the field. I tried but it gives me a > nullPointerException. > > this is the sql: > > select code_province, sum(%nameChamp%) as nbre_malade_prov, > province.the_geom from province, commune, commune_maladie where > code_province = province and commune_maladie.code_commune = > commune.code_commune and id_maladie = %id_maladie% group by code_province , > province.the_geom > > in the default value of the nameChamp i give it "nombre_2003"
Please provide the full stack trace, just "nullpointerexception" does not say anything to us. Cheers Andrea -- ------------------------------------------------------- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 962313 http://www.geo-solutions.it http://geo-solutions.blogspot.com/ http://www.youtube.com/user/GeoSolutionsIT http://www.linkedin.com/in/andreaaime http://twitter.com/geowolf ------------------------------------------------------- ------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
