Le portail francophone de la géomatique

LAYER
NAME "communes"
METADATA
  "wms_title" "communes"
  "ows_include_items" "nom_comm" 
END
TEMPLATE "fake.html"
STATUS OFF
CONNECTION "user=*** password=*** dbname=*** host=***"
CONNECTIONTYPE POSTGIS
DATA "the_geom from communes"
TYPE POLYGON
LABELITEM 'nom_comm'
CLASS
       NAME 'Communes' 
       STYLE
         SYMBOL 0 
         SIZE 2 
         OUTLINECOLOR 153 255 102
       END
    END
PROJECTION
"init=epsg:27593"
END
DUMP TRUE
END

    map.events.register('click', map, findLayerClick);
                
    function findLayerClick(event) {

    layerlist = "communes";

    mouseLoc = map.getLonLatFromPixel(event.xy);

    var url = wms1.getFullRequestString({
        REQUEST: "GetFeatureInfo",
        EXCEPTIONS: "application/vnd.ogc.se_xml",
        BBOX: map.getExtent().toBBOX(),
        X: event.xy.x,
        Y: event.xy.y,
        INFO_FORMAT: 'text/html',
        QUERY_LAYERS: layerlist,
        FEATURE_COUNT: 1,
        WIDTH: map.size.w,
        HEIGHT: map.size.h},
        "http://localhost/cgi-bin/mapserv.exe?map=c:/ms4w/Apache/htdocs/projet_test/natura.map");
 
    OpenLayers.loadURL(url, '', this, setHTML);

    Event.stop(event);
                }

    function setHTML(response) {
        alert(response.responseText);
    }

LAYER
NAME "communes"
METADATA
  "wms_title" "communes"
  "wms_feature_info_mime_type" "text/plain"
  "wms_include_items" "all" 
END
TEMPLATE "ttt"
STATUS OFF
CONNECTION "user=*** password=*** dbname=*** host=***"
CONNECTIONTYPE POSTGIS
DATA "the_geom from communes"
TYPE POLYGON
LABELITEM 'nom_comm'
CLASS
       NAME 'Communes' 
       STYLE
         SYMBOL 0 
         SIZE 2 
         OUTLINECOLOR 153 255 102
       END
    END
PROJECTION
"init=epsg:27593"
END
DUMP TRUE
END

    map.events.register('click', map, function(event) {
    var url = communes.getFullRequestString({
            REQUEST: "GetFeatureInfo",
            EXCEPTIONS: "application/vnd.ogc.se_xml",
            BBOX: communes.map.getExtent().toBBOX(),
            X: event.xy.x,
            Y: event.xy.y,
            INFO_FORMAT: 'text/plain',
            QUERY_LAYERS: communes.params.LAYERS,
                                     WIDTH: communes.map.size.w,
            HEIGHT: communes.map.size.h});

    //OpenLayers.loadURL(url, '', this, setHTML);
    OpenLayers.Util.getElement('nodeList').innerHTML = url;
    Event.stop(event);
});

GetFeatureInfo results:

Layer 'communes'
Content-type: application/vnd.ogc.se_xml

<?xml version='1.0' encoding="ISO-8859-1" standalone="no" ?>
<!DOCTYPE ServiceExceptionReport SYSTEM "http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd">
<ServiceExceptionReport version="1.1.1">
<ServiceException>
msPOSTGISLayerGetShape(): Query error. Error executing POSTGIS SQL statement (in FETCH ALL): DECLARE mycursor2 BINARY CURSOR FOR SELECT &quot;oid&quot;::text,&quot;id_bdcarto&quot;::text,&quot;nom_comm&quot;::text,&quot;insee_comm&quot;::text,&quot;statut&quot;::text,&quot;x_commune&quot;::text,&quot;y_commune&quot;::text,&quot;superficie&quot;::text,&quot;population&quot;::text,&quot;insee_cant&quot;::text,&quot;insee_arr&quot;::text,&quot;nom_dept&quot;::text,&quot;insee_dept&quot;::text,&quot;nom_region&quot;::text,&quot;insee_reg&quot;::text,asbinary(force_collection(force_2d(the_geom)),'NDR') from communes WHERE OID = 52
-ERROR:  DECLARE CURSOR can only be used in transaction blocks

More Help:
msPOSTGISLayerRetrievePGVersion(): Query error. Error executing POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for (position('on' in version()) - 13))
msPOSTGISLayerRetrievePGVersion(): Query error. Error executing POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for (position('on' in version()) - 13))
msPOSTGISLayerRetrievePGVersion(): Query error. Error executing POSTGIS statement (msPOSTGISLayerRetrievePGVersion():select substring(version() from 12 for (position('on' in version()) - 13))
</ServiceException>
</ServiceExceptionReport>

var lon = 237004.702965;
var lat = 146667.632985;
var zoom = 0;
var map;
var popup;
var panel, control1, info;
var wms1;

        
function init() { 

...
         
    info = new OpenLayers.Control.WMSGetFeatureInfo({
                 url: 'http://127.0.0.1/cgi-bin/mapserv.exe?map=/ms4w/apps/tutorial/htdocs/ASE_LIEGE_GFI.map&', 
                 title: 'Identify features by clicking',
             'displayClass': 'Info',
                 queryVisible: true,
                 eventListeners: {
                 getfeatureinfo: function(event) {
                
         if (popup != null) {
                 popup.destroy();
                 popup = null;
                 }
                
         if (event.text != "") {
        popup = new OpenLayers.Popup.AnchoredBubble("BatiInfo",
                map.getLonLatFromPixel(event.xy),
                new OpenLayers.Size(80,80),
                event.text,
                null,
                true);
                
                popup.setBackgroundColor("#E20030");
                popup.setOpacity(.9);
        map.addPopup(popup);}//end if
                
                }//end getfeatureinfo
            }// end eventListeners
        });//end info 
         
        map.addControl(info);
        info.activate();

    panel = new OpenLayers.Control.Panel({div: document.getElementById("panel")});
             
    panel.addControls([control1,info]);
             
        map.addControl(panel);
}//end init