Widow pop up is empty...
I have read this thread https://www.mail-archive.com/search?l=pmapper-users@lists.sourceforge.net&q=subject:%22[pmapper-users]+digitize+points%22&o=newest&f=1 and a try this query SELECT *, ST_Distance_Sphere(%s, %s) AS %s in my postgres but i have this error Errore SQL: ERROR: syntax error at or near "%" LINE 1: SELECT *, ST_Distance_Sphere(%s, %s) AS %s ^ Nel costrutto: SELECT *, ST_Distance_Sphere(%s, %s) AS %s no errors are reported in the connection db $db = DB::connect($dsn, true); if (DB::isError($db)) die ($db->getDebugInfo()); __________________________________________________ include_config.php $dsn = 'pgsql://user:pass@host:5432/dbname'; $db_table = 'toponimi-cat'; // Table name. $pkey = 'gid'; // Table's primary key. $the_geom = 'the_geom'; // Table's geometry field, type POINT. $srid_geom = 32633; // SRID of the geometry. $srid_map = 32633; // SRID of the map (clicked screen point). $tolerance = 500; // Distance in meteres to pick existing point for editing. $hide_fields = array('id'); // Table fields not displayed in the edit form. FILE map MAP EXTENT 350117.586532 4739786.469378 382150.132577 4773295.848327 IMAGECOLOR 255 255 255 UNITS meters SIZE 600 500 SHAPEPATH "/var/www/data" SYMBOLSET "../common/symbols/symbols-pmapper.sym" FONTSET "../common/fonts/msfontset.txt" RESOLUTION 96 IMAGETYPE png PROJECTION 'proj=utm' 'zone=33' 'datum=WGS84' 'units=m' 'no_defs' END LAYER NAME "Toponimi" TYPE POINT DUMP true TEMPLATE void EXTENT 360833.947860 4755676.707881 371581.165203 4766312.758308 CONNECTIONTYPE postgis CONNECTION "dbname='xxx' host=localhost port=5432 user='xxxx' password='xxx' sslmode=disable" DATA 'the_geom FROM "toponimi-cat" USING UNIQUE gid USING srid=32633' METADATA 'ows_title' 'toponimi-cat' END STATUS ON PROJECTION 'proj=utm' 'zone=33' 'datum=WGS84' 'units=m' 'no_defs' END LABELITEM "topo" CLASS NAME 'toponimi-cat' STYLE SYMBOL "square" SIZE 3.0 OUTLINECOLOR 0 0 0 COLOR 255 255 0 END LABEL POSITION Auto COLOR 0 0 0 BUFFER 2 TYPE truetype ENCODING "UTF-8" FONT FreeSans SIZE 7 MAXSIZE 9 #SIZE small END #Label END END help! thank you Eleonora ------------------------------------------------------------------------------ BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT Develop your own process in accordance with the BPMN 2 standard Learn Process modeling best practices with Bonita BPM through live exercises http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_ source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF _______________________________________________ pmapper-users mailing list pmapper-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/pmapper-users