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
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
-
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
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
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
Hai..My Name is Lies Umi Kulsum.
I want to ask how to load .png file into pmapper??
how bout the code??
--
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, in
