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 http://svn.pmapper.net/trac/wiki/FaqDebugging Report any error you get, including some debugging info. Include the map file, etc. There's a whole bunch of things you need to do and analyze. Armin On 17/10/2008 15:46, Andreas Haux wrote: > 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 >>> pmapper-users@lists.sourceforge.net >>> 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 pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
