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='xxxx'
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
