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
Username is testperson
Password is testpassword
and I would like to select all the geometries where the field NAME is
<searchstring>
Here is your example where I have tried to fill this informations in,
but I failed - I would simply like to establish a connection but did
not know how to handle username and password (since the XML file is
open to the public I could/would not include it here):
<searchitem name="testsearch" description="Only a test">
<layer type="postgis" name="testfile">
<field type="s" name="name" description="City"
wildcard="2">
<definition type="suggest" connectiontype="db"
sort="asc" minlength="1" dependfld="cmcncd">
<dsn encoding="UTF-8">pgsql://
postgres:[EMAIL PROTECTED]/testdb</dsn>
<sql>SELECT DISTINCT name FROM testtfile WHERE
name ~* '^[search]' ORDER BY name</sql>
</definition>
</field>
</layer>
</searchitem>
As far as I understand I don't need the suggest type in my case
instead of receiving the results immediately at the map. So the most
simple example how to write a request with PostGIS would be appreciated!
Thanks for your help!
Regards
Andreas
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
