[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