[Chameleon] Query widget and PostGIS data

Thu Aug 12 09:33:49 EDT 2004

Peter,

I know that the query widget does return results from postgis layers for 
another app we are working on, so I suspect soemthing in the 
configuration of your layer ... but I cannot immediately see a problem. 
  I've cc'd Zak since he is working on the other app, and specifically 
the postgis part ... perhaps he has some ideas?

Paul

Peter L. Pulsifer wrote:

> Hi all,
> 
> I am attempting to query a layer of polygon data using chameleon 1.99 beta
> 1.  Using a shapefile as the data source I have no difficulties.  A valid
> query result is displayed.  However, when using a postgis connection to the
> same data, the query results page is empty/blank - no error messages
> (although some HTML is generated - see below).  I have also included the
> layer object listing for reference.
> 
> Any idea why the behaviour is different for the postgis connection?  
> 
> Thanks in advance for any assistance.
> 
> Peter
> 
> Peter L. Pulsifer
> Geomatics and Cartographic Research Centre
> Carleton University, Ottawa, Canada
> 
> 
> 
> Blank Postgis query result:
> 
> Shapefile Query Result:
> 
> Postgis result:
> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
> <HTML><HEAD>
> <META http-equiv=Content-Type content="text/html;
> charset=iso-8859-1"></HEAD>
> <BODY></BODY></HTML>
> 
> Layer object:
>   LAYER
>     NAME "coast10_polygon"
>     STATUS ON
>     CONNECTIONTYPE postgis
>     CONNECTION "dbname=add host=127.0.0.1"
>     DATA "the_geom from coast10_polygon_4326"
> #    DATA "PAL.shp"   alternate connection to data in shapefile format
>     TYPE POLYGON
>     DUMP TRUE
>     TOLERANCE 10
>     TOLERANCEUNITS PIXELS
>     TEMPLATE "ttt_query.html"
> 
>     METADATA
>       "wms_name"  "ADD41_SCALE10"
>    	"wms_title" "ADD 4.1 Coastline Polygons (10)"
> 	"wms_srs" "EPSG:4326"
>       "wms_onlineresource"
> "http://127.0.0.1/cgi-bin/mapserv_42?map=/ms4w/apps/scar/samples/map/world_w
> ms.map&"
> 	"wms_formatlist"  "image/png,image/gif,image/jpeg,image/wbmp"
>       "wms_server_version"  "1.1.1"
> 	"wfs_title" "coast10_polygon"
>     END
>     
>     PROJECTION
> 	"init=epsg:4326"
>     END
>     
>     CLASSITEM "cst10srf"
>     CLASS
>       NAME "Ice shelf"
>       EXPRESSION "ice shelf"
>       COLOR 230 245 245
>       OUTLINECOLOR 185 185 185
>     END
>     CLASS
>       NAME "Land"
>       EXPRESSION "land"
>       COLOR 220 240 239
>       OUTLINECOLOR 205 205 205
>     END
>     CLASS
>       NAME "Ocean"
>       EXPRESSION "ocean"
>       COLOR 152 217 233
>     END
>     CLASS
>       NAME "Rumple"
>        EXPRESSION "rumple"
>       COLOR 0 174 231
>       OUTLINECOLOR 200 200 200
>     END
>     CLASS
>       NAME "Ice Tongue"
>       EXPRESSION "ice tongue"
>       COLOR 14 74 128
>       OUTLINECOLOR 155 155 155
>     END
>   END 
> 
> 
> _______________________________________________
> Chameleon mailing list
> Chameleon at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/chameleon
> 

-- 
  -----------------------------------------------------------------
|Paul Spencer                           pspencer at dmsolutions.ca   |
|-----------------------------------------------------------------|
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
  -----------------------------------------------------------------