Without providing debug information nobody can and/or will help you very much. Neither for the XY layers nor for the join problem. See debugging FAQ here
http://svn.pmapper.net/trac/wiki/FaqDebugging Regarding the XY layers I don't understand exactly why one would want to display dBase files like this... why not directly create a complete shapefile, or a SQlite file, or load it into a DB If for whatever reasons you have to stick to dBase, the following options appear to me: use dBase via ODBC: I would in any case recommend linking the dbf into an Access file and use it from there via ODBC, not directly create an ODBC connection to the dbf. Anyhow, you need to debug not just the connection, that is quite simple and will probably rarely fail. You need to also check the whole query, checking eg. the debug log of p.mapper (see above). use OGR: - VRT files instead of XY layers (just google for it) - configuration for joins of shapefile and dbase, see Mapserver OGR docs for XY files only: just create a shapefile out of dBase using 10 lines of PHP MapScript code. The JOIN tag in MapServer will probably not help you in p.mapper since they seem to work only when using the query templates of Mapserver, which p.mapper does not. armin On 11/10/2010 13:30, Andrea Genito wrote: > Hi all, > i have a new question...for you > is it possible use a dbf file (using an odbc connection) as an xy layer??? > i'm tring but without success. the point doesn't appear in the map but onli > the > loading windows > > I'm using pmapper 4.0 and mapserver 5.2.1 (installed with ms4w 2.3.1 stable > version) on a windows server 2003 machine (32 bit os and service pack 2) > > following there is the layer tag in the map file i'm using: > > > # > # Start of Layer table3.dbf > # > LAYER > NAME "punti_monitoraggio_xy" > TYPE POINT > PROJECTION > #"init=epsg:3004" > "+proj=tmerc +lat_0=0 +lon_0=15 +k=0.9996 +x_0=2520000 +y_0=0 +ellps=intl > +units=m +no_defs" > END #Projection > MAXSCALE 5100 > TOLERANCE 20 > TOLERANCEUNITS pixels > METADATA > "DESCRIPTION" "xy" > "RESULT_FIELDS" "SIGLA,LINK,TRIMESTRE" > "RESULT_HEADERS" "Sigla,Link,Trimestre" > "RESULT_HYPERLINK" "LINK" > "XYLAYER_PROPERTIES" "odbc://'':''/localh...@tabelle||table3||X2,Y2" > END # Metadata > TEMPLATE void > CLASS > Name 'XY' > STYLE > SYMBOL "../../images/metrob1/punti_monitoraggio/atm.png" > SIZE 30 > COLOR 0 0 200 > END # Style > TEMPLATE void > END # Class > END # Layer > > I already have installed the DB and MDB2 pear package, created the odbc > connection (with dsn system name) and tested the pear connection with the > following script (founded on the wiki > at http://svn.pmapper.net/trac/wiki/FaqConfiguration ): > > > <?php require_once('DB.php'); > $dsn = "odbc://'':''/localh...@tabelle"; > $dbh = DB::connect($dsn); > if (DB::isError($dbh)) { > die ($dbh->getDebugInfo()); > } > ?> > > > the test was succesfully cause (as the wiki says) the resut page was blank. > > > I'm sure the connection was succesful cauce i'm using a join with this table. > > Where i was wrong??? > > > > ------------------------------------------------------------------------------ > Beautiful is writing same markup. Internet Explorer 9 supports > standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2& L3. > Spend less time writing and rewriting code and more time creating great > experiences on the web. Be a part of the beta today. > http://p.sf.net/sfu/beautyoftheweb > _______________________________________________ > pmapper-users mailing list > pmapper-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/pmapper-users > ------------------------------------------------------------------------------ Beautiful is writing same markup. Internet Explorer 9 supports standards for HTML5, CSS3, SVG 1.1, ECMAScript5, and DOM L2 & L3. Spend less time writing and rewriting code and more time creating great experiences on the web. Be a part of the beta today. http://p.sf.net/sfu/beautyoftheweb _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users
