Thanks for answering, I try with you help, but the problems remain... At the moment some exercise on OGR connection run well like this: In my file.map:
...... CONNECTIONTYPE OGR CONNECTION "../../dati_clima/subbacini_new.shp // is the path to the shape file DATA "SELECT nome, id_sbac FROM subbacino_new" With this lines the server respond with only the shape file select in the DATA field. When I try to add the select with the join table the server dosn't respond. I suppose that the problem would be in the CONNECTION string because I do not have the possibility to add the other join file (dbf) to the shapefile. I try also with : CONNECTIONTYPE OGR CONNECTION "../../dati_clima" DATA "SELECT nome, id_sbac FROM subbacino_new" with the CONNECTION setted with the same string as the SHAPEPATH where all the data are stored but also in this cases the problem remain. NO RESPONSE !!!!! At 13.29 05/09/2007, you wrote: >Lorenzo, > >I am using a separate dbf file with CONNECTIONTYPE OGR. For example: > >... >CONNECTIONTYPE OGR >CONNECTION "/var/www/demodata" //path to folder where the shapefile with >its dbf file resides >DATA "SELECT a.ID, b.NAME FROM a LEFT JOIN b ON a.ID=b.ID" //b.pdf is >separate dbf file, b is table in b.dbf ... >CLASSITEM 'b.NAME' >... > >Maybe this can help you. > >regards, dejan > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On > > Behalf Of Lorenzo Bottai > > Sent: Wednesday, September 05, 2007 1:12 PM > > To: [email protected] > > Subject: [pmapper-users] joining table and classification problem > > > > Dear all, > > I would like to know if it is possible to use a field present > > in an joined table in order to classified a shape file. > > I try with this map file attach below. > > The join operation works perfectly and the query function > > produce the expected results, but when I use the class as > > show below,pmapper dosn't works. > > > > Could you suggest something ? > > > > I prefer to separate attribute data respect the geometric > > one, and I do not want to make a big table permanently joined > > with dbf of the shape file. > > > > ..... > > > > LAYER > > NAME "subbacino2" > > TYPE polygon > > STATUS ON > > DATA 'subbacino_new' > > > > METADATA > > "DESCRIPTION" "subbacino Cumulate (mm)" > > "RESULT_FIELDS" "NOME,ID_SBAC" > > "RESULT_HEADERS" "NOME,ID_SBAC,DIF_PERC,DIF_CL_07,CLIM_S_L,P_SET_LUG" > > "RESULT_JOIN" > > "odbc://'':''/[EMAIL PROTECTED]||[EMAIL PROTECTED]@[EMAIL PROTECTED] > > PERC,DIF_CL_07,CLIM_S_L,P_SET_LUG||ID_SBAC||0" > > END # Metadata > > > > CLASS > > NAME "570.91 - 646.78" > > EXPRESSION ([P_SET_LUG]>0 AND [P_SET_LUG]<=646) COLOR 254 225 > > 225 OUTLINECOLOR 0 0 0 TEMPLATE void END # Class > > > > > > ..... > > > > > > -------------------------------------------------------------- > > ----------- > > This SF.net email is sponsored by: Splunk Inc. > > Still grepping through log files to find problems? Stop. > > Now Search log events and configuration files using AJAX and > > a browser. > > Download your FREE copy of Splunk now >> > > http://get.splunk.com/ _______________________________________________ > > pmapper-users mailing list > > [email protected] > > https://lists.sourceforge.net/lists/listinfo/pmapper-users > > ------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
