[MAPSERVER-USERS] Problems using filters with GEODATABASE

[daa32]

Hi everyone!

I´m trying to use filters connecting with a GDB. I type the following in my
map file:

FILTERITEM "OTRAS_FORM"
FILTER ('[OTRAS_FORM]' = 'BANCO SUBMARINO' or '[OTRAS_FORM]' = 'HOYA
SUBMARINA')

The thing is if I inactive those lines mapserver works perfectly....but, of
course, without filters.

the error lines are:

"[Thu Sep 04 15:15:17 2008].578000 msOracleSpatialLayerWhichShapes():
OracleSpatial error. Error: ORA-00933: comando SQL no terminado
correctamente
 . Query statement: SELECT OBJECTID, OTRAS_FORM, SHAPE FROM (SELECT
OBJECTID, SHAPE, OTRAS_FORM FROM RN_GEODMG.INFO_OTRAS_FORMAS_MED_MAR) WHERE 
OTRAS_FORM =  '[OTRAS_FORM]' = 'BANCO SUBMARINO' or '[OTRAS_FORM]' = 'HOYA
SUBMARINA'  AND SDO_FILTER( SHAPE, MDSYS.SDO_GEOMETRY(2003, NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(60298.583,3980828.85,649701.417,4298521.15)
),'querytype=window') = 'TRUE' . Check your data statement.
[Thu Sep 04 15:15:17 2008].578000 msDrawMap(): Image handling error. Failed
to draw layer named 'morf_dv2'.
[Thu Sep 04 15:15:22 2008].937000 msOracleSpatialLayerWhichShapes():
OracleSpatial error. Error: ORA-00933: comando SQL no terminado
correctamente"

Thanks a million

cheers


-- 
View this message in context: http://www.nabble.com/Problems-using-filters-with-GEODATABASE-tp19309004p19309004.html
Sent from the Mapserver - User mailing list archive at Nabble.com.