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
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
