it takes *all* fields from the shape dbf because no METADATA "RESULT_FIELDS" is specified. The "RESULT_HEADERS" just adds a header line to the result table and has no influence on the displayed data. I guess you need to have at least 1 field from the dbf to be defined in "RESULT_FIELDS", otherwise it takes all.
armin Francesco Velluto wrote: > 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
