Hello Rolando, It might be something wrong on the definition of layer to search, or in the "FROM" parameter of the <sql> tag.
<layer type="postgis" name="caminoschaco-sep" <sql>SELECT DISTINCT tipo FROM red_vial WHERE Check if there is not a problem in the name of the layer on mapfile or in the PostGIS table name. Best regards, Pedro ----- Original Message ----- From: pelin 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 ------------------------------------------------------------------------------ 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------------------------------------------------------ Magic Quadrant for Content-Aware Data Loss Prevention Research study explores the data loss prevention market. Includes in-depth analysis on the changes within the DLP market, and the criteria used to evaluate the strengths and weaknesses of these DLP solutions. http://www.accelacomm.com/jaw/sfnl/114/51385063/ _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
