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"

thanks for the help

--
View this message in context: 
http://osgeo-org.1803224.n2.nabble.com/parameter-is-the-name-of-the-field-in-sqlView-tp6410468p6410468.html
Sent from the GeoServer - User mailing list archive at Nabble.com.

------------------------------------------------------------------------------
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

Reply via email to