[Chameleon] Query postgis layer
eric at gomoos.org
Fri Nov 12 17:05:18 EST 2004
On Fri, 2004-11-12 at 14:33, Mark M wrote:
> I can plot and query information from shp files. When I add a layer from postgis as in ,
> CONNECTION "user=postgres dbname=water host='127.0.0.1'"
> CONNECTIONTYPE POSTGIS
> DATA "the_geom from (SELECT local_coordinates AS the_geom, locale.oid AS oid, name
> from locale)
> USING UNIQUE oid USING SRID=-1"
> TEMPLATE "ttt_query.html"
> I can see the points but when I try to query them I get 'The layers did not return any results'. I can still query the shp files without a probelm. Any idea what's up?
to your POSTGIS layer.
More information about the Chameleon