Dear pmapper-users, when I define queries to the shapefile, everything works correctly, but when I define query to the table imported from this shapefile to postgis database, pmapper doesn't answer. Of course I change layer type from 'shape' to 'postgis' in config_default.xml file. It's strange for me because it is posible to see information about object, only query doesn't work so connection to database is correct. I found some tips in Internet which could help but nothing happened after this modifications. For example I've tried to change definition of data in mapfile from "DATA "geom from stacjepkp USING UNIQUE gid USING srid=2180"" to "DATA "geom from (SELECT geom, gid, kas, wc FROM stacjepkp) AS new_tab USING UNIQUE gid USING SRID=2180"".
The only idea which I have now, is to change something in mapfile but I don't know what. Maybe could you send me some example file which works to compare? Now definition of the layer looks this: (I've changed only the password) LAYER NAME "stacjepkp" STATUS ON DUMP true TYPE POINT EXTENT 14.331985 53.838422 14.538733 53.987097 #DATA "stacjepkp" CONNECTIONTYPE POSTGIS CONNECTION "host=skng.amu.edu.pl port=5432 dbname=postgres user=skng password=password" DATA "geom from stacjepkp USING UNIQUE gid USING srid=2180" #DATA "geom from (SELECT geom, gid, kas, WC FROM stacjepkp) AS new_tab USING UNIQUE gid USING SRID=2180" TOLERANCE 4 #promień okręgu od miejsca kliknięcia myszy TEMPLATE void CLASS NAME "stacjepkp" STYLE COLOR 0 0 0 SYMBOL "pkp" SIZE 18 END #koniec obiektu STYLE END #koniec obiektu CLASS METADATA "wms_title" "stacjepkp" "DESCRIPTION" "stacjepkp" "RESULT_FIELDS" "Kas, WC" "LAYER_ENCODING" "UTF-8" "ows_title" "stacjepkp" END PROJECTION "init=epsg:4326" END #Koniec PROJECTION END This is the part of default_config.xml file: <searchitem name="stacjepkp" description="stacjepkp"> <layer type="postgis" name="stacjepkp"> <field type="n" name="Kas" description="Kasa biletowa (0 - brak ; 1 - jest)" wildcard="1" /> </layer> </searchitem> Please, just take a look on my website http://skng.amu.edu.pl/gis<http://skng.amu.edu.pl/serwer/pmapper/>and try to "search for ...stacjepkp" (write '0' or '1' there) and look what happened. Each clue will be priceless for me... Thanks a lot, Tomasz Łukaszczyk Adam Mickiewicz University ------------------------------------------------------------------------------ Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users