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">
<layer type="postgis" name="pfarreien">
<field type="s" name="pfarrei" description="Name"
wildcard="1" />
</layer>
</searchitem>
</searchlist>
- The layer name in the .map-file is "pfarreien"
- The database connection is defined in the map file
- The database is "world", the table is "bamberg_pfarreien"; but this
seems not to be neccessary here?
- The column of the table where the search shall took place is "pfarrei"
Everytime I start a search I only see the "working" image in the top
right corner and nothing happens.
After hours of testing - could you please have a look whether
something is wrong with the xml? Thanks!!
Regards
Andreas
--------------------------------------------------------------
screen & paper Werbeagentur GmbH
Firmensitz: Martin-Luther-Straße 6, D-85354 Freising
Telefon: +49-(0)8161-97 94-0
Telefax: +49-(0)8161-97 94-23
Registergericht: Freising, HRB 104 687
Geschäftsführer: Andreas Haux
http://www.screen-paper.de
http://www.csite.de
http://www.maps-on-demand.com
http://www.mapshop-online.de
--------------------------------------------------------------
Disclaimer
Der Inhalt dieser E- Mail ist ausschließlich für den bezeichneten
Adressaten bestimmt und enthält vertrauliche und/oder rechtlich
geschützte Informationen. Wenn diese E- Mail nicht an Sie persönlich
adressiert ist oder Sie die Vertretung sein sollten, so beachten Sie,
dass jede Form der Kenntnisnahme, Veröffentlichung, Vervielfältigung
oder die Weitergabe des Inhalts dieser E- Mail unzulässig ist.
This e-mail may contain confidential and/or privileged information. If
you are not the intended recipient (or have received this e-mail in
error) please notify the sender immediately and destroy this e-mail.
Any unauthorised copying, disclosure or distribution of the material
in this e-mail is strictly forbidden.
Am 17.10.2008 um 12:50 schrieb 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="cities10000eu_pg">
> <field type="s" name="name" description="City" wildcard="1" />
> </layer>
> </searchitem>
>
> For options/suggest username/passwd need to be defined in the dsn like
>
> <dsn encoding="UTF-8">pgsql://username:[EMAIL PROTECTED]/gisdb</dsn>
>
>
> armin
>
>
> On Fri, Oct 17, 2008 at 9:23 AM, Andreas Haux
> <[EMAIL PROTECTED]> wrote:
>> 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
>> [email protected]
>> https://lists.sourceforge.net/lists/listinfo/pmapper-users
>>
-------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
