[mapserver-users] Strange problem with FILTER and ITEMQUERY

[Smith, Michael ERDC-CRREL-NH]

We are passing a filter variable to an Oraclespatial layer that sets the where string of the query. This works great when we are doing mode=browse

(http://water.crrel.usace.army.mil/cgi-bin/mapserv362?mode=browse&map=/htdocs/dpg/dpg.map&mapext=1008461.320000+7130171.000000+1313080.680000+7333223.000000&mapsize=450+300&layers=landsatdem+zdi+zdihilight&urlvar=(ANALYTE='1,1,1,2-TETRACHLOROETHANE')

However, when we pass essentially the same url but use mode=itemquery 

(http://water.crrel.usace.army.mil/cgi-bin/mapserv362?map=../html/dpg/dpg.map&urlvar=(ANALYTE='1,1,1,2-TETRACHLOROETHANE')&mapsize=450+300&&layer=landsatdem&layer=zdi&layer=zdihilight&mode=itemquery&qlayer=qsli&item=GRID_CODE&monloc=14) 

I get a very strange error 

(msOracleSpatialLayerWhichShapes(): OracleSpatial error. ORA-00911: invalid character . SQL statement: SELECT rownum, locid, SHAPE FROM (select l.locid, l.shape from ldi l where l.locid in (select d.locid from dpg_chemdata d WHERE 156rlvar%))

Basically, it is not passing the filter variable and seems to be corrupting the variable name.

Any ideas? 

I plan to start looking through the code but I'm not sure which module would contain the problem.

Mike Smith
email: michael.smith at erdc.usace.army.mil
RSGISC
ERDC - CRREL 
Hanover, NH  03755
(603) 646-4765