I threw IE away :), added your string in .map, tried with (IE again), Mozilla and Chrome but had the same result: neverending LOADING bar Date: Tue, 25 Nov 2008 15:53:10 +0100 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [email protected] Subject: Re: [pmapper-users] problem in connecting to PostGIS layers from p.mapper
Stefano Gambini ha scritto: Hi Walter, Thanks for the prompt reply. Change you suggest applied but still not working. I have this message in the state bar: "Errore nella visualizzazione della pagina" and a popup window with: Linea: 93 Carattere: 17 Errore: Errore di sintassi Codice 0 URL: http://localhost/pmapper/prova_postgis/map.phtml ahhh this tell me that are you using IE :(... I think it's a derivated error for postgis layer Notice I can open the underlying raster (rectifyvilla_aerea_e_logoi). It's only when i tick the postgis layer in the TOC that the application gets stuck. Clear .. depend on this postgis layer Try to put in map file a sql like this: DATA "the_geom from (select the_geom, * from monumenti_postgis) AS new_tab USING UNIQUE gid" without SRID if you are sure that in you geometry_columns table is specified the srid for your monumenti_postgis table W Stefano Date: Tue, 25 Nov 2008 15:30:10 +0100 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] CC: [email protected] Subject: Re: [pmapper-users] problem in connecting to PostGIS layers from p.mapper Stefano Gambini ha scritto: Hi Stefano, I'm a new user and find some problem in connecting to PostGIS layers from p.mapper. I have created a PostGIS layer of points and added to .map file as follows: LAYER NAME "monumenti_postgis" TYPE POINT CONNECTIONTYPE postgis CONNECTION "user=postgres password=**** dbname=postgis host=localhost port=5432" STATUS ON DATA "the_geom from monumenti_postgis USING UNIQUE oid USING SRID = 32733" Are you sure that your monumenti_postgis table has OIDS? Try to remove USING UNIQUE OID and replace with USING UNIQUE gid TOLERANCE 10 TOLERANCEUNITS pixels METADATA "DESCRIPTION" "Monumenti a rischio" "RESULT_FIELDS" "id,rischio,nome" "RESULT_HEADERS" "Monumento ID,Classe sismica,Nome" END # Metadata CLASS COLOR 0 0 255 END # Class END # Layer Also added monumenti_postgis to config.ini: allGroups = monumenti_postgis, rectifyvilla_aerea_e_logoi Still the LOADING bar goes on forever when I try to open it from p.mapper Notice that I'm able to open monumenti_postgis with, ex, QGIS. Have a doubt: My general p.mapper folder is in D:\ms4w\apps\pmapper-3.1-beta4\ whereas my particular project in D:\ms4w\apps\pmapper-3.1-beta4\prova_postgis\ is correct there isn't another place W _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Walter Lorenzetti email: [EMAIL PROTECTED] skype: aiki74 Cell: (+39) 347-6597931 Tel+Fax: (+39) 0583 926684 Via di Tofori 123a 55010, Camigliano-S.Gemma Lucca Italy _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users -- Walter Lorenzetti email: [EMAIL PROTECTED] skype: aiki74 Cell: (+39) 347-6597931 Tel+Fax: (+39) 0583 926684 Via di Tofori 123a 55010, Camigliano-S.Gemma Lucca Italy _________________________________________________________________ Discover the new Windows Vista http://search.msn.com/results.aspx?q=windows+vista&mkt=en-US&form=QBRE ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ pmapper-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/pmapper-users
