Solved!
There were some fields upper case and others in lower case, in my Postgres DB.
A.
Da: Alberto Laurenti a.laure...@yahoo.it
A: pmapper-users@lists.sourceforge.net
Inviato: Ven 16 luglio 2010, 15:11:04
Oggetto: [pmapper-users] search attributes on postgres/postgis layer
Hi all,
I've many postgis layers in my mapfile. I'm able to make a search for a field
in
a polygon layer but not in a point layer. In this second case (layer Test)
search starts but nothing happens. I attach mapfile and config_default.xml.
Any hints? Thanks in advance
MAPFILE
=
[...]
LAYER
NAME 'test'
TYPE POINT
CONNECTIONTYPE postgis
CONNECTION dbname='dbname' host=localhost port=5432 password=''
user='postgres'
DATA the_geom FROM test USING UNIQUE gid USING SRID=-1
METADATA
#'wms_title' 'test'
RESULT_FIELDS
id_punto,nome_ortof,strato_uso,strato_u_1,quota_pop,istatr,istatp,istatc
RESULT_HEADERS Codice Punto,Ortofoto,Uso del suolo,Uso del suolo
2,Quota,Istat Reg,Istat Pro,Istat Com
END
STATUS OFF
TRANSPARENCY 100
PROJECTION
init=epsg:3004
END
TEMPLATE void
CLASS
NAME 'test'
STYLE
SYMBOL 'CIRCLE'
SIZE 4
OUTLINECOLOR 0 0 0
COLOR 255 0 0
END
END
END
[.]
CONFIG_DEFAULT.XML
[.]
searchlist version=1.0
dataroot$/dataroot
searchitem name=provincia description=Provincia (nome)
layer type=postgis name=ita_pro_gbe
field type=s name=provincia description=Nome della
Provincia wildcard=0 /
/layer
/searchitem
searchitem name=sigla description=Provincia (sigla)
layer type=postgis name=ita_pro_gbe
field type=s name=sigla description=Sigla della
Provincia wildcard=0 /
/layer
/searchitem
searchitem name=ID_punto description=Codice PUNTO
layer type=postgis name=test
field type=n name=id_punto description=Codice PUNTO
wildcard=1/
/layer
/searchitem
/searchlist
[.]
--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
___
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users