maybe you can try to limite the output field in the metadata "$$$_include_items" "$$$_exclude_items" tag : ... DATA "SHAPE FROM MAPSERVER_TRIMQ USING UNIQUE MAXIMO_ID SRID 32632 VERSION 10g" ... METADATA ... "wms_exclude_items" "ALL" "wms_include_items" "MAXIMO_ID, ASSETTYPE" "oms_exclude_items" "ALL" "ows_include_items" "MAXIMO_ID, ASSETTYPE" "gms_exclude_items" "ALL" "gml_include_items" "MAXIMO_ID, ASSETTYPE" END ...
>>> Kristian Thy <[EMAIL PROTECTED]> 7/6/2008 18:49 >>> Hi list I've made a small openlayers viewer that shows a data layer from a materialized view in Oracle Spatial. When clicking on the map, I do a simple GetFeatureInfo which works when I test it with a shapefile-based layer, but when I move to the Oracle layer, I get an error message saying that no features were found with MAXIMO_ID = 0 (something to that effect, anyways). Unfortunately this is an internal GIS app, so I can't demo it. The relevant layer definition in my map file: ------------------------------------------------------------------------ LAYER NAME 'TRIM-Q' TYPE POINT CONNECTIONTYPE oraclespatial CONNECTION "[EMAIL PROTECTED]" DATA "SHAPE FROM (SELECT MAXIMO_ID, ASSETTYPE, SHAPE FROM MAPSERVER_TRIMQ) USING UNIQUE MAXIMO_ID SRID 32632 VERSION 10g" TEMPLATE "trim.html" HEADER "trim_header.html" FOOTER "trim_footer.html" TOLERANCE 20 DUMP true METADATA "wms_title" "TRIM-Q" "wms_srs" "EPSG:32632" "wms_include_items" "ALL" "ows_include_items" "ALL" "gml_include_items" "ALL" END #metadata CLASS NAME 'vejskab' EXPRESSION ('[ASSETTYPE]' = 'VEJSKAB') STYLE SYMBOL 'square' OFFSET -4 -2 END #STYLE LABEL type truetype antialias true font arial_black size 8 position ll color 0 0 0 outlinecolor 255 255 255 buffer 2 partials false END #label TEXT ([MAXIMO_ID]) END #class CLASS #NAME faerdselstavle EXPRESSION ('[ASSETTYPE]' = 'TAVLE') STYLE SYMBOL 'triangle' OFFSET -10 2 END #STYLE LABEL FORCE true type truetype antialias true font arial_black size 8 position lc color 0 0 0 outlinecolor 255 255 255 buffer 0 partials false end #label TEXT ([MAXIMO_ID]) END #class CLASS #NAME 'other values' STYLE SYMBOL 'circle' SIZE 2 COLOR 100 0 0 END #STYLE LABEL type truetype antialias true font arial_black size 8 position uc color 0 0 0 outlinecolor 255 255 255 buffer 2 partials false end #label TEXT ([MAXIMO_ID]) END #class SIZEUNITS PIXELS STATUS ON UNITS meters MAXSCALE 60000 LABELMAXSCALE 60000 END #layer ------------------------------------------------------------------------ The OpenLayers code I use for calling GetFeatureInfo: ------------------------------------------------------------------------ map.events.register('click', map, function (e) { var url = trimq.getFullRequestString({ REQUEST: 'GetFeatureInfo', EXCEPTIONS: 'application/vnd.ogc.se_xml', BBOX: trimq.map.getExtent().toBBOX(), X: e.xy.x, Y: e.xy.y, INFO_FORMAT: 'text/plain', QUERY_LAYERS: 'TRIM-Q', RADIUS: 5, WIDTH: trimq.map.size.w, HEIGHT: trimq.map.size.h}); document.getElementById('map').style.cursor = 'wait'; OpenLayers.loadURL(url, '', this, handleResponse); Event.stop(e); }); function handleResponse(response) { document.getElementById('map').style.cursor = 'auto'; alert(response.responseText); } ------------------------------------------------------------------------ As mentioned, this works if I query a shapefile-based layer, so I assume the javascript is ok. Any ideas what my problem is? \\kristian -- ... et nemo ex vobis interrogat me: »Quo vadis?« _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users