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 ------------------------------------------------------------------------- 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
