OracleSpatial QueryAttribute

[Fernando Simon]

Hi,
    How did you define your queryAttribute function in your Mapscript
code? This problem can be with the way how you used the quer
function. Can you post your code?
    I'm not in the lab today, so I can't check the maporaclespatial.c
to find a possible problem in functions. Just in the next week.
    Best regards.

----------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
Laboratorio de Computacao Aplicada
UNIVALI/CTTMAR - Brazil
----------------------------------------


Citando Hallgren Johan E <jhhal at WMDATA.COM>:

> Hello,
> 
>  
> 
> No I have tried the OracleSpatial Native support. Everything works
> fine
> until I try to queryAttributes. 
> 
>  
> 
> I don't get the expected results but I can se that the following
> SQL is
> sent to Oracle.:
> 
>  
> 
> --------------------------
> 
> SELECT OBJECTID, , shape FROM (SELECT objectid, shape, fnr_fds
> FROM
> bergvikmark_sdo) WHERE FNR_FDS = &apos;200205688&apos; AND
> SDO_FILTER(
> shape, MDSYS.SDO_GEOMETRY(2003, NULL,
>
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(70420.
> 8121,6043080.13,3097864.19,7727610.88) ),'querytype=window') =
> 'TRUE'
> 
> --------------------------
> 
>  
> 
> As I can see the problem is in the beginning, "SELECT OBJECTID, ,".
> I
> tried to look at the code and in maporaclespatial.c/
> msOracleSpatialLayerWhichShapes() (I think that's functions is
> used)
> 
>  
> 
> I don't understand what's wrong...
> 
>  
> 
> I'm using mapserver-4.8.1
> 
> Oracle 10.1 (windows Server)
> 
> I'm using the MapScript api.
> 
>  
> 
> MapFile:
> 
> CONNECTION "wmgis/xxx at wmsi1394"
> 
> CONNECTIONTYPE oraclespatial 
> 
> DATA "shape FROM (SELECT objectid, shape, fnr_fds FROM
> bergvikmark_sdo)
> USING UNIQUE OBJECTID VERSION 10g" 
> 
>  
> 
> I have also tried the 
> 
> DATA "shape FROM bergvikmark_sdo USING UNIQUE OBJECTID VERSION 10g"
> 
> 
>  
> 
> But the same result.
> 
>  
> 
> Any ideas?
> 
>  
> 
> /Johan
> 
> ___________________________________
> 
> 
> Johan Hallgren
> WM-data
> 
> 
> Pelle Bergs backe 3
> Box 1938, 791 19 Falun
> Tel: 023-844 65 (int: +46-2384465)
> 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::http://www.wmdata.se> 
> 
>  
> 
> 




-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br