to,
processed by and stored on NIWA's IT systems.
From: mapserver-users on behalf of
Lime, Steve D (MNIT)
Sent: Wednesday, February 13, 2019 08:39
To: Stephen Woodbridge; mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Help with failing Postgis query
To: mapserver-users@lists.osgeo.org
Subject: Re: [mapserver-users] Help with failing Postgis query...
Brent,
Are you wrapping your query like:
DATA "select * from (select ROW_NUMBER() OVER (order by code) as id,
code, sci_name, com_name, lower(family_com)||' ('|| family_sci||')' as
F
Brent,
Are you wrapping your query like:
DATA "select * from (select ROW_NUMBER() OVER (order by code) as id,
code, sci_name, com_name, lower(family_com)||' ('|| family_sci||')' as
Family, point from rdb.species_master s, maps.null_point p where code in
(select distinct species from
Hi,
I'm getting an error with an SQL in a mapfile.
The query works from from the command line:
select ROW_NUMBER() OVER (order by code) as id, code, sci_name, com_name,
lower(family_com)||' ('|| family_sci||')' as Family, point from
rdb.species_master s, maps.null_point p where code in