On Mon, 06 May 2013 20:44:30 +0200, Armin Burger wrote: > I would suggest you set the debugging level to a higher value like 3 > and > then check the query logging in the debug log,
It already was set to level 3. > see > > > http://svn.pmapper.net/trac/wiki/FaqDebugging#a3.Enablep.mapperdebugging > > it should contain the queries sent to PG. It doesn't. All I can find, is this: PHP Notice: Undefined variable: dynamicClasses in /home/geogf405/site_balades/incphp/layerview.php on line 218 Don't really know how to interpret that. I did get see some PG queries before, so there must be something wrong with my file. I'll try again tomorrow morning. Thanks for the support and the great tool ! Moritz > > On 05/06/2013 05:34 PM, Moritz Lennert wrote: >> Hello, >> >> I have two PostGIS layers: one with lines representing hiking paths, >> one >> with polygons representing administrative units, with the mapfile >> definitions in [1]. >> >> I am trying to elaborate a query in pmapper which would allow to >> select >> an admin unit in an options list and then in a second field select >> amongst the hikes that cross through that admin unit. >> >> To start with, one general question: is it possible to create an >> options >> list dependent on the first options list (i.e. chose an admin unit >> in >> the first list and the get a second options list with only those >> hikes >> that cross that admin unit), or does the second field have to be a >> suggest field ? >> >> Now, even using a suggest field in the second part, I just can't >> seem to >> get the correct config to make it work. >> >> At [0] is the searchitem definition. >> >> At this stage, I don't get any error message, but searches are >> empty, >> even though executing them directly in PostgreSQL works. >> >> No error message in the postgresql, php or apache2 logs... >> >> Any hints ? >> >> Moritz >> >> >> [0] Searchitem definition >> >> <searchitem name="balades_selon_communes" >> description="Choisir >> une balade selon une commune bruxelloise"> >> <layer type="postgis" name="balades_avec_communes"> >> <field type="s" name="muniname1" description="Nom >> de la >> commune" wildcard="2"> >> <definition type="options" connectiontype="db" >> sort="asc" firstoption="Sélectionner une commune" nosubmit="1"> >> <dsn >> encoding="UTF-8">pgsql://USER:PASSWD@SERVER/DATABASE</dsn> >> <sql>SELECT DISTINCT muniname1,muniname1 FROM >> communes ORDER BY muniname1</sql> >> >> >> <events>onchange="resetSuggestCache();$('#pmsfld_name').val('')"</events> >> </definition> >> </field> >> >> <field type="s" name="name" description="Nom de la >> balade" wildcard="2"> >> <definition type="suggest" connectiontype="db" >> minlength="1" sort="asc" firstoption="Sélectionner une balade" >> dependfld="muniname1"> >> <dsn >> encoding="UTF-8">pgsql://USER:PASSWD@SERVER/DATABASE</dsn> >> <sql>SELECT DISTINCT name,name FROM balades >> JOIN >> communes ON (ST_Crosses(ST_Transform(balades.the_geom, 31370), >> communes.the_geom)) WHERE name ~* E'^[search]' AND muniname1 = >> '[dependfldval]' ORDER BY name</sql> >> </definition> >> </field> >> </layer> >> </searchitem> >> >> >> >> >> [1] Mapfile definitions >> >> #admin units >> LAYER >> NAME 'communes' >> TYPE POLYGON >> TEMPLATE void >> CONNECTIONTYPE postgis >> CONNECTION "dbname='MyDatabase' host=localhost port=5432 >> user='MyUser' password='MyPassword' sslmode=disable" >> DATA 'the_geom FROM (SELECT gid, the_geom, muniname1 FROM >> communes) >> as subquery USING UNIQUE gid USING srid=31370' >> METADATA >> "DESCRIPTION" "communes" >> "RESULT_FIELDS" "gid,muniname1" >> "RESULT_HEADERS" "ID,Nom" >> "ows_title" "communes" >> "LAYER_ENCODING" "UTF-8" >> END >> TRANSPARENCY 100 >> PROJECTION >> "init=epsg:31370" >> END >> CLASS >> NAME 'communes' >> STYLE >> WIDTH 1 >> OUTLINECOLOR 0 0 0 >> END >> END >> END >> >> #hikes >> LAYER >> NAME "balades" >> TYPE LINE >> TEMPLATE void >> CONNECTIONTYPE postgis >> CONNECTION "dbname='MyDatabase' host=localhost port=5432 >> user='MyUser' password='MyPassword' sslmode=disable"#Prendre >> simplement >> tous les champs de la table balades >> DATA "the_geom FROM (SELECT b.gid, b.the_geom, b.name, >> b.duree_minutes, b.longueur_metres, upper(a.prenom) || ' ' || >> upper(a.nom) as nom, a.email, a.section FROM balades b JOIN auteur a >> ON >> (b.id_auteur = a.id)) AS SUBQUERY USING UNIQUE gid USING srid=4326" >> >> METADATA >> "RESULT_FIELDS" >> "name,duree_minutes,longueur_metres,nom,section" >> "RESULT_HEADERS" "BALADE,DUREE (min),LONGUEUR >> (m),AUTEUR,SECTION" >> "DESCRIPTION" "Balades" >> "ows_title" "balades" >> "LAYER_ENCODING" "UTF-8" >> END #Metadata >> PROJECTION >> "init=epsg:4326" >> END #Projection >> CLASS >> NAME 'Balades' >> COLOR 255 0 0 >> END #Class >> END #Layer >> >> >> >> >> ------------------------------------------------------------------------------ >> Introducing AppDynamics Lite, a free troubleshooting tool for >> Java/.NET >> Get 100% visibility into your production application - at no cost. >> Code-level diagnostics for performance bottlenecks with <2% overhead >> Download for free and get started troubleshooting in minutes. >> http://p.sf.net/sfu/appdyn_d2d_ap1 >> _______________________________________________ >> pmapper-users mailing list >> pmapper-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/pmapper-users >> > > > > ------------------------------------------------------------------------------ > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and > their applications. This 200-page book is written by three acclaimed > leaders in the field. The early access version is available now. > Download your free book today! http://p.sf.net/sfu/neotech_d2d_may > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. This 200-page book is written by three acclaimed leaders in the field. The early access version is available now. Download your free book today! http://p.sf.net/sfu/neotech_d2d_may _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
