Hello Armin and Pedro:
I have a similar situation...or not!.
In my config_default.xml I have:
***************
<searchlist version="1.0">
<dataroot>$</dataroot>
<searchitem name="caminoschaco-sep" description="Caminos">
<layer type="postgis" name="caminoschaco-sep">
<field type="s" name="tipo" description="TipoCamino"
wildcard="2">
<definition type="suggest" connectiontype="db" sort="asc"
minlength="1" startleft="1">
<dsn encoding="UTF-8">pgsql://mapas:mapas@postgisServer
/DBmapas</dsn>
<sql>SELECT DISTINCT tipo FROM red_vial WHERE tipo ~*
'^[search]' ORDER BY tipo</sql>
</definition>
</field>
</layer>
</searchitem>
...........
...............
...............
..............
***************
But I don't have suggestions in search, no info in php or pmapper logs, only
database logs:
*******************
2011-07-22 09:28:57 ART [2749]: [1-1] LOG: statement: SELECT gid,
xmin(box3d(the_geom)),
ymin(box3d(the_geom)),
xmax(box3d(the_geom)),
ymax(box3d(the_geom)),
tipo,nombre,jurisdicci,clase,transitabi,nombreruta,refer_mapa,jurisdic,nombre_2
FROM red_vial as red_vial
WHERE tipo = 'HUELLA'
LIMIT 301
2011-07-22 09:28:57 ART [2749]: [2-1] LOG: duration: 23.307 ms
2011-07-22 09:28:58 ART [4392]: [1657-1] LOG: statement: select * from
red_vial as red_vial where false limit 0
...............
................
*********************
of course I must write the full text for query
thanks in advance!
--
Atentamente
Rolando Sergio Rodriguez
DIT Direccion de Informacion Territorial - SPER
Provincia del Chaco Marcelo T. de Alvear 145 - 9no Piso de Casa de Gobierno
Tel: 03722-456426 (Directo)
03722-448000 int. 6426
Cel: 03722-15-814858 (red win)
BB Messenger: 22F397A7
http://etisig.chaco.gov.ar
http://etisig.siup.gov.ar
<<attachment: search.jpg>>
------------------------------------------------------------------------------ 10 Tips for Better Web Security Learn 10 ways to better secure your business today. Topics covered include: Web security, SSL, hacker attacks & Denial of Service (DoS), private keys, security Microsoft Exchange, secure Instant Messaging, and much more. http://www.accelacomm.com/jaw/sfnl/114/51426210/
_______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
