Thanks, Now I just need that chest. lol
On Wed, 27 May 2009 16:29:54 -0700, Peter Willis
wrote:
> Hello,
>
> Darn!, I just sent a [RESOLVED] with the same solution.
> (just as I was receiving your email...)
> Yes, this is how I managed to to make it work.
>
> Everything works now.
> I guess yo
Hello,
Darn!, I just sent a [RESOLVED] with the same solution.
(just as I was receiving your email...)
Yes, this is how I managed to to make it work.
Everything works now.
I guess you get the badge for that one.
Thanks for your help.
Peter
Simon Haddon wrote:
Have you tried
DATA 'the_geom
Have you tried
DATA 'the_geom from (select oid,gid, the_geom,
"Area","Perimeter","PixelValue" FROM "global_Land_poly" WHERE
"PixelValue"=1 )
AS FOO using SRID=4326'
The other options is to change the table name and column names to be lower
case or case insensitive. Mixed case table and
I tried that. I get the following error:
loadLayer(): Unknown identifier. Parsing error near (Area):(line 30)
Mapserver doesn't appear to like the additional formatting.
Do I need to recompile with system regex I wonder?
Peter
Adam Eskreis wrote:
You could try regex
\"Area\"
-Adam
On
You could try regex
\"Area\"
-Adam
On Wed, May 27, 2009 at 6:48 PM, Peter Willis wrote:
>
> Hello,
>
> I am having a problem serving a PostGIS layer via mapserver
> as WFS.
>
> The problem arises from the generation/use of column names
> in PostgreSQL that require double quotes.
>
> ie:
>
> S
Hello,
I am having a problem serving a PostGIS layer via mapserver
as WFS.
The problem arises from the generation/use of column names
in PostgreSQL that require double quotes.
ie:
SELECT oid,gid, the_geom, "Area","Perimeter","PixelValue" FROM
global_Land_poly WHERE "PixelValue"=1;
In th