Sorted. Now working. The problem was the primary key of the table. Thanks to 
the hint of Davide Zizioli, another of this list, I gave OID as primary key and 
added  DATA "the_geom from monumenti_postgis USING UNIQUE oid USING SRID=32733" 
to the .map to make the connection working.

I made another layer and gave it gid as primary key. It also works.

Now i'll try to modify the data, via php, and do multiple queries with 
search.xml

Thanks a lot to all of you. "See" you for my next issue.

Stefano

Date: Tue, 25 Nov 2008 18:08:56 +0100
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
CC: pmapper-users@lists.sourceforge.net
Subject: Re: [pmapper-users] problem in connecting to PostGIS layers from 
p.mapper






  


Stefano Gambini ha scritto:

Sorry sure,


  

  

Postgresql reports the error as 'ERROR:  column reference "the_geom" is
ambiguous

LINE 1: ...SOR FOR SELECT
asbinary(force_collection(force_2d(the_geom))...

                                                             ^

  


Try to remove the_geom inside the () and left only * this should be
work :)

I hope 



W

-- 

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
_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx
-------------------------------------------------------------------------
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
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users

Reply via email to