<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
h3
{mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:13.5pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:595.3pt 841.9pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=SV link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>Hello,<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>No I have tried the OracleSpatial Native support. Everything
works fine until I try to queryAttributes. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I don’t get the expected results but I can se
that the following SQL is sent to Oracle.:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>--------------------------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>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'<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>--------------------------<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>As I can see the problem is in the beginning, “SELECT
OBJECTID, ,”. I tried to look at the code and in maporaclespatial.c/</span></font><font
size=2 face=Verdana><span lang=EN-GB style='font-size:10.0pt;font-family:Verdana'>
msOracleSpatialLayerWhichShapes() (I think that’s functions is used)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I don’t understand what’s wrong…<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I’m using mapserver-4.8.1<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>Oracle 10.1 (windows Server)<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I’m using the MapScript api.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>MapFile:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>CONNECTION "wmgis/xxx@wmsi1394"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>CONNECTIONTYPE oraclespatial <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Verdana><span
lang=EN-GB style='font-size:10.0pt;font-family:Verdana'>DATA "shape FROM
(SELECT objectid, shape, fnr_fds FROM bergvikmark_sdo) USING UNIQUE OBJECTID
VERSION 10g" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>I have also tried the <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face=Verdana><span
lang=EN-GB style='font-size:10.0pt;font-family:Verdana'>DATA "shape FROM bergvikmark_sdo
USING UNIQUE OBJECTID VERSION 10g" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>But the same result.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>Any ideas?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Verdana><span lang=EN-GB style='font-size:
10.0pt;font-family:Verdana'>/Johan<o:p></o:p></span></font></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'>___________________________________<o:p></o:p></span></font></p>
<div>
<h3 style='margin:0cm;margin-bottom:.0001pt'><u1:PERSONNAME ProductID="Johan Hallgren" u2:st="on"><b><font
size=3 color=black face=Arial><span style='font-size:12.0pt;font-family:Arial;
color:black'><u3:PersonName ProductID="Johan Hallgren" u4:st="on">Johan Hallgren<br>
</u3:PersonName></span></font></b><font size=1 color=black face=Arial><span
style='font-size:9.0pt;font-family:Arial;color:black'></u1:PERSONNAME>WM-data</span></font><o:p></o:p></h3>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><font
size=1 color=black face=Arial><span style='font-size:9.0pt;font-family:Arial;
color:black'>Pelle Bergs backe 3<br>
<st1:address u5:st="on"><st1:Street u5:st="on">Box</st1:Street> 1938</st1:address>, 791
19 Falun<br>
Tel: 023-844 65 (int: +46-2384465)<br>
Mobil: 070-588 44 28 (int: +46-705884428)<br>
</span></font><u><font size=1 color=blue face=Arial><span style='font-size:
9.0pt;font-family:Arial;color:blue'>johan.e.hallgren</span></font></u><font
size=1 color=black face=Arial><span style='font-size:9.0pt;font-family:Arial;
color:black'><a href="BLOCKED::mailto:johan.e.hallgren@wmdata.com"
target="_blank"
title="mailto:johan.e.hallgren@wmdata.com blocked::mailto:johan.e.hallgren@wmdata.com mailto:johan.e.hallgren@wmdata.com"><span
title="mailto:johan.e.hallgren@wmdata.com">@wmdata.com</span></a></span></font><u><font
size=1 color=blue face=Arial><span style='font-size:9.0pt;font-family:Arial;
color:blue'><br>
</span></font></u><font size=1 color=black face=Arial><span style='font-size:
9.0pt;font-family:Arial;color:black'><a href="BLOCKED::http://www.wmdata.se"
target="_blank"
title="http://www.wmdata.se/ blocked::/exchweb/bin/redir.asp?URL=http://www.wmdata.se/ /exchweb/bin/redir.asp?URL=http://www.wmdata.se/"><span
title="http://www.wmdata.se/">http://www.wmdata.se</span></a></span></font><font
size=2 color=black face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:black'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>