Hi,
this is my first post in this mailing list. First of all i wish make
congratulation for your work on pmapper and thanks you to share it.
Now my issue with RESULT_JOIN.
I'm using GRASS and i created a vector file. I connected it to a mysql
attribute table. I exported it in SHAPE format because it seems that the
proprietary grass vector format (each vector is a set of files) is not
supported by mapserver. The export procedure create a complete set of files
and among those there's the DBF file too.
Now with p.mapper I'm trying to connect the above MYSQL database to the shp
file:
METADATA
"RESULT_HEADERS" "id,Nome,Popolazione"
"RESULT_JOIN" "mysql://user:[EMAIL PROTECTED]/database||[EMAIL PROTECTED]@0
@id,City,Population||id||0"
END
In the pop up query window the results is a duplicate entry. Something near
this:
*********************************************************************
id City
Population
1 New York 18000000 1 New York
18000000
*********************************************************************
I made some test tinkering with "RESULT_HEADERS" parameter and i found that
the first 3 fields belong to the DBF of the shape file while the last 3
fields belong to the MYSQL database.
There's a way to cut off the DBF files in pmapper ? I have to use the data
in the MYSQL database because they must be edited by an externale php
application.
Thanks for your help,
Francesco Velluto
-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier.
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
pmapper-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/pmapper-users
