----- Forwarded Message ----
From:Hose <hosejon...@yahoo.com>
To: pmapper-users@lists.sourceforge.net
Sent:Mon, September 13, 201010:25:03AM
Subject: Zoom to pre-defined extent
Hi,
I am using MS4W 4.0.0with Pmapper.
I have the Oracle spatial layer that works great. The problem is if i wont to
customize the disply of the oraclespatial layer by URL. The identify works,
search works.
(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 local shape it works like it
should.
:
[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.
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
The Second thing that i am trying to figure out is if it is possible to use the
expression in URL
(http://localhost/pmapper/map.phtml?config=slo&zoomLayer=gerk&zoomquery=kmg_...@0@100227...@0@1??&FILTER??
) with same effect that FILTER in layer definition has.
Thank you
------------------------------------------------------------------------------
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
