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
