Hello,
My name is Jose.
I am using MS4W package with MapServer Version 5.2.2 and Pmapper 4.0.0.
I have the Oracle spatial layer that works great. The problem is if i want
to
customize the display layer that DATA = "oraclespatial" by URL. If i call
the map by:
(Extent read from layer feature:
http://localhost/pmapper/map.phtml?config=slo&zoomLayer=gerk&zoomquery=kmg_...@0@100227...@0@1)
I get the following error in log. If i use it on the same .shp that is
located on local directory it works like it
should.
This is what i get from Error log:
[Mon Sep 1310:09:362010].721000msOracleSpatialLayerWhichShapes. Using this
Sql
to retrieve the data: SELECT GERK_PID, KMG_MID, GEOM FROM SLO_GERK_MID WHERE
KMG_MID = KMG_MID = 100227877 AND SDO_FILTER( GEOM,
MDSYS.SDO_GEOMETRY(2003,
2170,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(362824,10426,630953,221543)
),'querytype=window') = 'TRUE'
[Mon Sep 1310:09:362010].721000msOracleSpatialLayerWhichShapes():
OracleSpatial
error. Error: ORA-00933: SQL command not properly ended
. Query statement: SELECT GERK_PID, KMG_MID, GEOM FROM SLO_GERK_MID WHERE
KMG_MID = KMG_MID = 100227877 AND SDO_FILTER( GEOM,
MDSYS.SDO_GEOMETRY(2003,
2170,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(362824,10426,630953,221543)
),'querytype=window') = 'TRUE' . Check your data statement.
[Mon Sep 1310:09:362010].721000msOracleSpatialLayerFreeItemInfo was called.
>From Error log it looks that when i call the map with URL settings and the
layer data is from Oraclespatial it generates the SELECT statement in the
way that doubles the FIELD after WHERE KMG_MID = KMG MID = XXXXXXX
The .map layer definition is :
LAYER
NAME "gerk"
TYPE polygon
connectiontype oraclespatial
connection "XXXX/xx...@xxxxxx"
PROCESSING "CLOSE_CONNECTION=DEFER"
DATA "GEOM from SLO_GERK_MID USING UNIQUE GERK_PID SRID 2170"
TRANSPARENCY 30
TEMPLATE void
PROJECTION
#"init=epsg:4326"
#"+proj=longlat +ellps=WGS84+datum=WGS84+no_defs no_defs"
END
METADATA
"DESCRIPTION" "Gerk"
"RESULT_FIELDS" "GERK_PID, RABA_ID,KMG_MID"
"RESULT_HEADERS" "Gerk, Raba, kmg_mid"
"LAYER_ENCODING" "Windows-1250"
"ows_title" "gerk"
END # Metadata
CLASSITEM 'KMG_MID'
CLASS
Name 'Gerk'
COLOR 2552550
OUTLINECOLOR 000
END # Class
END # Layer
Thank you.
--
View this message in context:
http://old.nabble.com/Starting-URL-on-oraclespatial-layer-%22-zoomLayer%22-returns-error.-tp29706872p29706872.html
Sent from the pmapper users mailing list archive at Nabble.com.
------------------------------------------------------------------------------
Start uncovering the many advantages of virtual appliances
and start using them to simplify application deployment and
accelerate your shift to cloud computing.
http://p.sf.net/sfu/novell-sfdev2dev
_______________________________________________
pmapper-users mailing list
pmapper-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/pmapper-users
