Thank Armin for you help
I am working whit p.mapper version 1.0.8
Thank for mapfile maneger
regards
------------ pr?xima parte ------------
Se ha borrado un adjunto en formato HTML...
URL:
http://www.faunalia.com/pipermail/pmapper-users/attachments/20051018/73726efb/attachment.htm
From [EMAIL PROTECTED] Wed Oct 19 08:49:27 2005
From: [EMAIL PROTECTED] (Walter Lorenzetti)
Date: Wed Oct 19 08:50:05 2005
Subject: [Pmapper-users] query postgis bug
In-Reply-To: <[EMAIL PROTECTED]>
References: <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> <[EMAIL PROTECTED]>
Message-ID: <[EMAIL PROTECTED]>
Alle 19:29, marted? 18 ottobre 2005, hai scritto:
Sorry, Armin
the_geom from (select ...) as newtable using unique OID ...
this way is correct to search postgis layers
Bye
Walter
> What does 'bug fixed' mean in this context?
>
> Armin
>
> Walter Lorenzetti wrote:
> > Alle 18:24, luned? 17 ottobre 2005, Armin Burger ha scritto:
> > Thanks Armin,
> >
> > the bug is fixed!
> >
> > All the best
> > Walter
> >
> >>Walter,
> >>
> >>I tested it with a PG dataset. If I define the DATA tag as
> >>
> >>the_geom from (select ...) as newtable using unique gid ..."
> >>
> >>then I get an error. If I define it
> >>
> >>the_geom from (select ...) as newtable using unique OID ..."
> >>
> >>then the error does not appear. The attribute search uses the OID field
> >>to uniquely identify a feature and add it to the resultlayer for
> >>highlighting. The OID field is the only one that is guaranteed existing
> >>in every PG table.
> >>
> >>Maybe this helps.
> >>
> >>Armin
> >>
> >>Armin Burger wrote:
> >>>Do you by chance specify the PostgIS layer as
> >>>"the_geom from (select ...) as newtable using unique gid ..." ?
> >>>
> >>>armin
> >>>
> >>>>--- Urspr?ngliche Nachricht ---
> >>>>Von: Walter Lorenzetti <[EMAIL PROTECTED]>
> >>>>An: [EMAIL PROTECTED]
> >>>>Kopie: Armin Burger <[EMAIL PROTECTED]>
> >>>>Betreff: Re: [Pmapper-users] query postgis bug
> >>>>Datum: Mon, 17 Oct 2005 13:10:17 +0200
> >>>>
> >>>>Alle 19:10, venerd? 14 ottobre 2005, hai scritto:
> >>>>Hi Armin,
> >>>>
> >>>>i try to do what you said me and i obtain OID that is correct!
> >>>>I try to use 1.9.4 pmapper version but the bug persist
> >>>>
> >>>>For me the problem is another:
> >>>>when i use multi-search-info (it works) in the apache-log i see that
> >>>>$resShpIdx is not OID postgis record but it's the gid, instead in
> >>>> search procedure $resShpIdx is OID, so the pmap_addResultLayer()
> >>>> function in map.php
> >>>>is blocked at $newResLayer->addFeature($resShape), this is correct?
> >>>>
> >>>>Bie Walter
> >>>>
> >>>>>Did you try the new version 1.9.4? There were some bugs for attribute
> >>>>>searches on Postgis layers until then. I was hoping that they had been
> >>>>>solved with the new version. I can remember that I got that problem,
> >>>>> but do not know any more what was the reason for it.
> >>>>>
> >>>>>The problem comes from that it cannot find the shape based on the
> >>>>>supplied feature ID. It uses this feature ID to identify the feature
> >>>>>used for the highlighting. And it does not find the feature in the
> >>>>>postgis layer with that id.
> >>>>>
> >>>>>Write out the feature to the PHP error log, using something like
> >>>>>error_log("OID: $resShpIdx");
> >>>>>
> >>>>>after the line
> >>>>>
> >>>>>$resShape = $qLayer->getShape($resTileShpIdx, $resShpIdx);
> >>>>>
> >>>>>in map.php
> >>>>>
> >>>>>Then look in the postgis DB if you can find the feature using
> >>>>>select * from your_table where oid = [the_id_from_$resShpIdx]
> >>>>>
> >>>>>
> >>>>>Armin
> >>>>
> >>>>--
> >>>>Walter Lorenzetti
> >>>>[EMAIL PROTECTED] www.faunalia.it www.faunalia.com
> >>>>Via di Tofori 123 - 55010 Camigliano (LU), Italy Tel:
> >>>> (+39)347-6597931
> >>
> >>_______________________________________________
> >>Pmapper-users mailing list
> >>[EMAIL PROTECTED]
> >>http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
--
Walter Lorenzetti
[EMAIL PROTECTED] www.faunalia.it www.faunalia.com
Via di Tofori 123 - 55010 Camigliano (LU), Italy Tel: (+39)347-6597931
