[Chameleon] Querying Oracle layer with Query widget

Jussi Rasinmäki jussi.rasinmaki at helsinki.fi
Thu Apr 14 12:35:07 EDT 2005


Hi list,

I've some trouble getting the Query-widget to work with an Oracle layer.
The map draws and zooms OK, but when I use the query tool PHP crashes and an
entry is generated in Apaches error.log.
I'm using a modification of the latest MS4W on W2K, with the exception that
mapserver.exe and assosiated libraries are replaced with a version with OCI
support compiled in.

Below extracts from relevant files.

Cheers,

Jussi Rasinmäki

Map-file
=============================================
  # Start of LAYER DEFINITIONS ---------------------------------------------
  LAYER
    NAME Maa
    TYPE POLYGON
    CONNECTIONTYPE ORACLESPATIAL
    CONNECTION usr/pwd at sid
    DATA "GEOLOC FROM (SELECT ID, GEOLOC, TUNNUS, PINTAMAALAJI, POHJAMAALAJI
FROM MAA) USING UNIQUE ID SRID 294913"
    STATUS DEFAULT
    TEMPLATE "query.html"
    TOLERANCE 3
    TOLERANCEUNITS PIXELS
    CLASSITEM "TUNNUS"
    CLASS
      EXPRESSION 'Ve'
      COLOR 232 232 232
    END
    CLASS
      EXPRESSION 'Ka'
      COLOR 198 198 255
    END
    PROJECTION
      "init=epsg:2392"
    END
  END # Maa polygon layer ends here

=============================================

Template.html
=============================================
              <cwc2 type="Query"
                visible="true"
                imagetip="Identify Feature"
                popupwidth="500"
                popupheight="600"
                radius="3"
                maxfeatures="5"
                IMAGEWIDTH="24"
                 IMAGEHEIGHT="24">
                    <IMAGE STATE="normal"
                              IMAGE="buttons/button_query_1.png"/>
                    <IMAGE STATE="hover"
                              IMAGE="buttons/button_query_2.png"/>
                    <IMAGE STATE="selected" I
                            IMAGE="buttons/button_query_3.png"/>
              </cwc2>
=============================================

Apache error.log
=============================================
[Thu Apr 14 19:18:50 2005] [error] [client 127.0.0.1] Premature end of
script headers: php.exe, referer:
http://localhost/myapp/testi2.phtml?NAV_INPUT_TYPE=RECTANGLE&NAV_INPUT_COORDINATES=301%2C97%3B343%2C136&NAV_INPUT_SUBMIT=&MAP_EXTENTS_MINX=2499999&MAP_EXTENTS_MINY=6848749.125&MAP_EXTENTS_MAXX=2530000&MAP_EXTENTS_MAXY=6871249.875&MAP_WIDTH=400&MAP_HEIGHT=300&MAP_CURSOR_POS_X=343&MAP_CURSOR_POS_Y=136&NAV_CMD=ZOOM_IN&MAP_ORIGINAL_EXTENTS=2499999%2C6848749.125%2C2530000%2C6871249.875&MAP_ORIGINAL_PROJ=%2Binit%3Depsg%3A2392&CURSOR_TYPE=AUTO&BUTTON_TOOLSET_Navigation=cwcimage_1&NAV_ALLOW_RECTANGLE=true&LANGUAGE=en-CA

=============================================



More information about the Chameleon mailing list