Re: [pmapper-users] PostGIS layer does not return query info

Maybe you should add an internal PK to the table (integer type), use it in the view and then modify your mapfile as explain by Marcello : DATA "geom FROM your_table USING UNIQUE your_pk USING SRID=4326" Sidney Gijzen a écrit : > No, I mean querying by using the Identifier tool, so he has to find

Re: [pmapper-users] PostGIS layer does not return query info

No, I mean querying by using the Identifier tool, so he has to find the RESULT_FIELD I specified in the Map-file. I already double-checked it, and the RESULT_FIELD does exist in the DB. However it suddenly expects an integer as PK to return when I query.. and I have no integers in the DB-vi

Re: [pmapper-users] PostGIS layer does not return query info

You mean querying with search.xml? Sidney Gijzen a écrit : > Yes, I can display the layer without any problems. However, as soon as I > start querying it gives the PHP-error and the query result window > doesn't load. > > --

Re: [pmapper-users] PostGIS layer does not return query info

Yes, I can display the layer without any problems. However, as soon as I start querying it gives the PHP-error and the query result window doesn't load. -- Let Crystal Reports handle the reporting - Free Crystal Reports

Re: [pmapper-users] PostGIS layer does not return query info

Does your layer definition works fine ? Have you got errors when trying something like that: http://:/cgi-bin/mapserv.exe?mode=map&map=&layers= Sidney Gijzen a écrit : > Hi Thomas, > > Thank you for your suggestion! > > Changing the procedure_id to an integer in the DB is something I > actually

Re: [pmapper-users] PostGIS layer does not return query info

Hi Thomas, Thank you for your suggestion! Changing the procedure_id to an integer in the DB is something I actually can't change, since I'm working according to OGC SWE standards, and the procedure_id is defined as a "character varying" data type. So, that leaves your second option "change the

Re: [pmapper-users] PostGIS layer does not return query info

Hi, Now it seems to be a problem of types: "procedure_id" is a string and the "WHERE" try to evaluate it as a numeric value. You should try directly in your db (pgAdmin3 or psql client line interface for instance) the query extracted from the error log : "SELECT "procedure_id"::text,"procedure

Re: [pmapper-users] PostGIS layer does not return query info

You need a PK field for the postGIS Layer, try this: --view CREATE VIEW *procedure *AS SELECTprocedure.procedure_id AS *procedure_id*, procedure.description_url AS procedure_description_url, procedure.description_type AS procedure_description_type, feature_of_interest.feature_of_i

Re: [pmapper-users] PostGIS layer does not return query info

Hi Marcello, Thank you very much for your suggestion! I created a view (which works :)), however I get the following php-error when querying the layer: [27-Jul-2009 15:16:15] PHP Fatal error: [MapServer Error]: msPOSTGISLayerGetShape(): Error executing POSTGIS SQL statement (in FETCH ALL): D

[pmapper-users] PostGIS layer does not return query info

Hello, I forgot to add some version info. I'm working with the following setup: p.mapper 4.0 dev PostGIS 1.3.6 PostgreSQL 8.3 Mapserver 5.2.1 I hope this is helpful :) If you need more info, please ask. Thank you in advance, Sidney -

[pmapper-users] PostGIS layer does not return query info

Hi list! I've recently dived into p.mapper, and the documentation has been really helpful. I was able to join a few tables in a PostGIS DB and display that in p.mapper. However, I get the following PHP ERROR when I try to query this layer: [27-Jul-2009 11:57:16] PHP Fatal error: [MapServer Er

[pmapper-users] postgis layer

Hi, I found the solution: DATA "the_geom FROM (SELECT min(gid) AS gid, (geomunion(the_geom)) AS the_geom FROM parafie GROUP BY dekanat) foo USING UNIQUE gid" Bogumil - Check out the new SourceForge.net Marketplace.