Hello everyone,
My name is Moffat and I am using pmapper 4 which i have connected with
postgresql database. But i would like to also connect it with Mysql database
whereby a given query on a layer e.g parcels will display data from both
from Mysql and postgresql databases. I would appreciate any help on this.
This is how i have implemented the postgresql connection on the mapfile :
LAYER
NAME 'Block79_1'
TYPE POLYGON
CONNECTIONTYPE postgis
CONNECTION "dbname='lis' host=localhost port=5432 user='postgres'
password='mogima12'"
DATA 'the_geom FROM "Block79_1" USING UNIQUE oid USING srid=4326'
METADATA
'ows_title' 'Block79_1'
"DESCRIPTION" "Buru Buru Block 79_1"
"RESULT_FIELDS" "par_no,fr_no,reg_area_h,reg_dist,locality,landuse"
"RESULT_HEADERS" "Parcel Number,FR Number,Reg Area(HA),Reg
District,Locality,Landuse"
END
------------------------------------------------------------------------------
Colocation vs. Managed Hosting
A question and answer guide to determining the best fit
for your organization - today and in the future.
http://p.sf.net/sfu/internap-sfd2d
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
