Nuria,
you specified the field names in "RESULT_FIELDS" in upper case. I wrote
in the documentation "For shapefiles these fields have to be defined
completly in upper case". This implies that you do not have necessarily
to do it also for PostGIS layers. But that's a general
Mapserver/Postgres question, not related to pmapper. If you use
Mapserver CGI and query templates then you will have the same problems.
If the field names are 'normally' created in PostGIS (eg. using
shp2pgsql) without explicitly setting the field names in upper case then
they have to be in lower case (I think this is a speciality of Postgres
or the PG/Mapserver connector).
So try sepcifying the field names in lower case, then it should work.
Armin
Nuria Gonz?lez wrote:
> Hi Armin,
>
> I send you the map file.
> My problem is with "fueros_geom" layer.
> If I disable "RESULT_FIELDS" and "RESULT_HEADERS" I get all fields of
> the table, but if I put these labels (like in the map file that I send
> you), I get empty rows in the table (I see the RESULT_HEADERS but I
> don't see the RESULT_FIELDS).
>
> Thanks.
>
>
>
>
>> From: Armin Burger <[EMAIL PROTECTED]>
>> To: Nuria Gonz?lez <[EMAIL PROTECTED]>
>> CC: [EMAIL PROTECTED]
>> Subject: Re: [Pmapper-users] query postgis problems
>> Date: Tue, 18 Oct 2005 19:28:58 +0200
>>
>> Nuria,
>>
>> could you send me the map file? I cannot say much without knowing how
>> you define the layers and query attributes. Do you have empty rows or
>> no rows at all? Disable completely the METADATA entry for
>> "RESULT_FIELDS" and see what you get (should be ALL fields of the table).
>>
>> For the wrong extent, check the extent that is available in the JS
>> function when going with the mouse over the magnifying glass ('copy
>> link location' and paste in a text editor). For points you might need
>> to adapt the buffer settings in the squery.php. Sooner or later I will
>> add a comment in the docs about this problem.
>>
>> Armin
>>
>> Nuria Gonz?lez wrote:
>>
>>> Hi all,
>>>
>>> I've tried pmapper 1.0.8 and pmapper 1.9.4 and I've had the same
>>> problem in both versions.
>>>
>>> I have a postgis layer of points. These points are displayed right.
>>> When I get data with "identify" or "select" options I get a table
>>> with headers but without data in the rows. (This is a problem).
>>>
>>> On the other hand, when I search a data with "Search for" option, I
>>> get a table filled with the information (although the hyperlink
>>> doesn't work, the hyperlink doesn't appear), but an error occurs.
>>> This error is the following:
>>>
>>> [error] [client 127.0.0.1] PHP Fatal error: [MapServer Error]:
>>> setExtent(): Given map extent is invalid., referer:
>>> http://localhost/pmapper-1.9.4/map.phtml
>>> [error] [client 127.0.0.1] in C:\\Archivos de programa\\Apache
>>> Group\\Apache2\\htdocs\\pmapper-1.9.4\\incphp\\map.php on line 447,
>>> referer: http://localhost/pmapper-1.9.4/map.phtml
>>>
>>>
>>>
>>> Do you have any idea about my problem?
>>>
>>> Thanks in advance.
>>>
>>> _________________________________________________________________
>>> Moda para esta temporada. Ponte al d?a de todas las tendencias.
>>> http://www.msn.es/Mujer/moda/default.asp
>>>
>>>
>>> _______________________________________________
>>> Pmapper-users mailing list
>>> [EMAIL PROTECTED]
>>> http://faunalia.it/cgi-bin/mailman/listinfo/pmapper-users
>>>
>>>
>
> _________________________________________________________________
> Descarga gratis la Barra de Herramientas de MSN
> http://www.msn.es/usuario/busqueda/barra?XAPID=2031&DI=1055&SU=http%3A//www.hotmail.com&HL=LINKTAG1OPENINGTEXT_MSNBH
>
>
