[pmapper-users] Search XML with PostGIS

2008-10-17 Thread Andreas Haux
Hi, p.mapper is great - and I am experimenting for quite a while but didn't found out how exactly to define a search funktion in the search.xml file using PostGIS; the examples show the connection without sending a username and password. e.g.: Database name ist testdb Tablename is testfile

Re: [pmapper-users] Search XML with PostGIS

2008-10-17 Thread Armin Burger
Andreas have a look here http://svn.pmapper.net/trac/browser/pmapper/trunk/config/dev/search.xml If you do not need things like options/suggest then the definition should be quite straightforward: searchitem name=cities_pg description=City PG layer type=postgis name=cities1eu_pg

Re: [pmapper-users] Search XML with PostGIS

2008-10-17 Thread Andreas Haux
Armin, thanks for your feedback - and sorry for coming back with this issue. I have defined the XML as follows: ?xml version='1.0'? !-- ?xml-stylesheet href=style.xsl type=text/xsl ? -- searchlist version=1.0 dataroot$/dataroot searchitem name=pfarreien description=Pfarrei

Re: [pmapper-users] Search XML with PostGIS

2008-10-17 Thread Marcello Benigno
Hi Andreas and Armin, I have te *same problem* too. why it happens? I have defined the XML as follows: searchitem name=acudes_grupo description=Açudes layer type=postgis name=acudes field type=s name=ds_acude description=Nome do Açude wildcard=0 / /layer

Re: [pmapper-users] Search XML with PostGIS

2008-10-17 Thread Armin Burger
Andreas 1. Check all the error logs (mainly PHP, but also Javascript) 2. set the debugging to value 3 and analyze the debug output. You should get the query strings sent to the database. Try to launch this query directly on the database via a generic DB client. See the FAQ for more details

Re: [pmapper-users] Search XML with PostGIS

2008-10-17 Thread Armin Burger
see my mail to Andreas. In your case in addition: make you life easier and put your join in a DB view and try using this view as DATA. armin On 17/10/2008 16:38, Marcello Benigno wrote: Hi Andreas and Armin, I have te *same problem* too. why it happens? I have defined the XML as follows: