<div>Hi Simon,</div>
<div> </div>
<div>problem is solved,</div>
<div> </div>
<div>the Filter must be formatted somehow like:</div>
<div> </div>
<div>DATA "GEOLOC FROM E112_CELLS_GEO USING SRID 8307 FILTER"<br>FILTER "cell='BAMK5D'"</div>
<div> </div>
<div>the SRID seems to be a must for the filter.</div>
<div> </div>
<div>thanks again for your help.</div>
<div> </div>
<div>zhonghai<br><br> </div>
<div><span class="gmail_quote">On 6/26/06, <b class="gmail_sendername">Zhonghai Wang</b> <<a href="mailto:zhonghaiw@gmail.com">zhonghaiw@gmail.com</a>> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div>
<div>Hi Simon,</div>
<div> </div>
<div>how is everything? thanks for your hints.</div>
<div> </div>
<div>as you said, I set the Filter again like this:</div></div>
<div><span class="q">
<div> </div>
<div>DATA "GEOLOC FROM E112_CELLS_GEO USING FILTER"</div></span></div>
<div>
<div>FILTER "cell='BAMK5D'"</div>
<div> </div>
<div>with the cell='BAMK5D' condition in the SQLPlus 12 elements will be selected, but with mapserverit returns still some error messages:</div>
<div> </div>
<div>msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error: ORA-29902: error in executing ODCIIndexStart() routine<br>ORA-13208: internal error while evaluating [window SRID does not match layer SRID] operator<br>
ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 259<br>ORA-06512: at line 1<br> . Query statement: SELECT rownum, GEOLOC FROM E112_CELLS_GEO WHERE cell='BAMK5D' AND SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL, NULL,
MDSYS.SDO_ELEM_INF</div>
<div><span class="q"><br>O_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(5.95587,45.11214,10.49203,48.51426) )<br>,'querytype=window') = 'TRUE' . </span></div>
<div></div>
<div>Check your data statement.</div>
<div> </div>
<div>It seems that I should specify certain SRID code, but in this case the SRID code is not necessary.</div>
<div> </div>
<div>BTW: the SRID is 8307</div>
<div> </div>
<div>thanks</div></div>
<div><span class="sg">
<div> </div>
<div>zhonghai</div></span></div>
<div><span class="e" id="q_10c10c137a71ee97_6">
<div><br> </div>
<div><span class="gmail_quote">On 6/26/06, <b class="gmail_sendername">Fernando Simon</b> <<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:fsimon@univali.br" target="_blank">fsimon@univali.br</a>
> wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Hi,<br> Just remove the "WHERE" from FILTER parameter. Like: FILTER<br>"MI_PRINX =100"
<br> Best regards.<br><br>Fernando Simon<br><br>Zhonghai Wang wrote:<br>> Hi there,<br>><br>> I am trying to render the map with oracle spatial database, and facing<br>> problems with the FILTER expression.<br>
><br>> at first I define the oracle spatial connection like:<br>><br>> CONNECTIONTYPE ORACLESPATIAL<br>> CONNECTION "<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:E110/E110@PMCGIS2.WORLD" target="_blank">
E110/E110@PMCGIS2.WORLD</a> <mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:E110/E110@PMCGIS2.WORLD" target="_blank"> E110/E110@PMCGIS2.WORLD</a>>"<br>> DATA "GEOLOC FROM E112_CELLS_GEO USING UNIQUE MI_PRINX SRID 8307"
<br>><br>> and this one works fine, therefore I am sure that the mapfile<br>> definition is ok, and then I change the data connection to : <br>><br>> CONNECTIONTYPE ORACLESPATIAL<br>> CONNECTION "<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:E110/E110@PMCGIS2.WORLD" target="_blank">
E110/E110@PMCGIS2.WORLD</a> <mailto:<a onclick="return top.js.OpenExtLink(window,event,this)" href="mailto:E110/E110@PMCGIS2.WORLD" target="_blank">E110/E110@PMCGIS2.WORLD</a>>" <br>> DATA "GEOLOC FROM E112_CELLS_GEO USING FILTER"
<br>> FILTER "WHERE MI_PRINX =100"<br>><br>> to use the FILTER function for a specific selection, but this<br>> definition gives aan error instead of the map image: <br>><br>> ERROR:<br>> msOracleSpatialLayerWhichShapes(): OracleSpatial error. Error:
<br>> ORA-00936: missing expression .<br>> Query statement: SELECT rownum, GEOLOC FROM E112_CELLS_GEO WHERE WHERE<br>> MI_PRI <br>> NX=100 AND SDO_FILTER( GEOLOC, MDSYS.SDO_GEOMETRY(2003, NULL,<br>> NULL,MDSYS.SDO_ELE
<br>> M_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(5.95587<br>> ,45.11214,10.49203,48.514<br>> 26) ),'querytype=window') = 'TRUE' . <br>> Check your data statement.<br>><br>> I can not figure out where the problem is. the MI_PRINX is the unique
<br>> id of the table, if I make this query in the SQLPlus, the data will be<br>> returned, which means the where condition in the SQL is no problem. <br>><br>> any ideas for this?<br>><br>> kind regards
<br>><br>> zhonghai<br>><br>><br>><br>><br>><br><br></blockquote></div><br></span></div></blockquote></div><br>