Hi, I read name="Kas" in your search definition, but your subquery in your mapfile seems to use "kas" field and not "Kas".
I think there should be a case mistake. Thomas Le 27/08/2010 01:10, Sekcja Geoinformacji a écrit : > 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 > > > > > ------------------------------------------------------------------------------ This SF.net Dev2Dev email is sponsored by: Show off your parallel programming skills. Enter the Intel(R) Threading Challenge 2010. http://p.sf.net/sfu/intel-thread-sfd _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
