[Chameleon] Query postgis layer

[Mark M]

Hi,

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?

TIA
Mark
-- 
_______________________________________________
The coolest e-mail address on the web and it’s FREE!  Sign-up today for Beer Mail @ beer.com.