Antwort: [MAPSERVER-USERS] Problems using filters with GEODATABASE

[umn-ms at hydrotec.de]

Hello

1. Remove the Filteritem-line
2. Change Filter  to
FILTER (OTRAS_FORM = 'BANCO SUBMARINO' or OTRAS_FORM = 'HOYA SUBMARINA')
  or to
FILTER (OTRAS_FORM IN ('BANCO SUBMARINO','HOYA SUBMARINA'))

Bye
Benedikt Rothe

BTW: I think, when Mapserver creates the SQL-Statement 
(maporaclespatial.c/osFilteritem(...)) it should surround it
with braces. Combined with the spatial-filter mapserver creates 
a Where-Clause of the form 
"CondA OR CondB AND CondC".
IMHO: To make precedence to Oracle unambiguous clear, it should rather be 
"(CondA OR CondB) AND CondC".

mapserver-users-bounces at lists.osgeo.org schrieb am 08.09.2008 23:34:13:

> 
> 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.
> 
> _______________________________________________
> mapserver-users mailing list
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20080909/dd8cf4bf/attachment.htm>