queryByAttributes with IN (arg)

[Hallgren Johan E]

Sorry, the first mail went away...

 

I tries to use MapServer and Oracle Spatial. Shouldn't the following
statement work?

 

strWhere = "KOPPLINGSID in (6246,4730,4123)";

strFld  = "KOPPLINGSID";

 

oLayerObj.queryByAttributes(m_MapObj, strFld, strWhere,
mapscript.MS_MULTIPLE);

 

In the console I can read:

**********************

msOracleSpatialLayerOpen called with: shape FROM (SELECT rownum,
OBJECTID, GISSG

UID, KOPPLINGSID, XMAX, YMAX, XMIN, YMIN, DATNY, DATEDIT, NAMNNY,
NAMNEDIT, shap

e FROM FAT.GFAST ) USING NONE

msOracleSpatialLayerOpen. Shared connection not available. Creating one.

msConnPoolRegister(Fast,imsuser/imsuser at gisstest.world,00D85C68)

msOracleSpatialLayerFreeItemInfo was called.

msOracleSpatialLayerInitItemInfo was called.

msOracleSpatialLayerWhichShapes was called.

msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the data:
SELECT row

num, KOPPLINGSID, shape FROM (SELECT rownum, OBJECTID, GISSGUID,
KOPPLINGSID, XM

AX, YMAX, XMIN, YMIN, DATNY, DATEDIT, NAMNNY, NAMNEDIT, shape FROM
FAT.GFAST ) W

HERE KOPPLINGSID in

msOracleSpatialLayerFreeItemInfo was called.

msOracleSpatialLayerClose was called. Layer connection:
imsuser/imsuser at gisstest

.world

msOracleSpatialLayerClose. Cleaning layerinfo handlers.

msOracleSpatialLayerClose. Cleaning Oracle handlers.

msConnPoolRelease(Fast,imsuser/imsuser at gisstest.world,00D85C68)

**********************

 

The parenthesis with the argument is removed.

 

Is the in statement not supported in mapserver?

 

/Johan


___________________________________


Johan Hallgren


 

WM-data a LogicaCMG company 

Pelle Bergs backe 3

Box 1938, 791 19 Falun

Tel: 023-547 46 (int: +46-2354746)

Mobil: 070-588 44 28 (int: +46-705884428)

johan.e.hallgren at wmdata.com
<BLOCKED::mailto:johan.e.hallgren at wmdata.com> 

http://www.wmdata.se
<BLOCKED::/exchweb/bin/redir.asp?URL=http://www.wmdata.se/> 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-dev/attachments/20061124/41885fc6/attachment.html