<html xmlns:v="urn:schemas-microsoft-com:vml" 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>
<!--
/* 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:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hello<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I have a problem with MapServer 5.0 and Oracle when using </span></font><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>queryByAttributes.</span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Before I could use the following syntax;<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>oLayerObj.queryByAttributes(m_MapObj,
“OBJECTID”, “OBJECTID = 75”, <font color="#2b91af"><span
style='color:#2B91AF'>mapscript</span></font>.MS_MULTIPLE);</span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Now it does not work. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The debug error is;<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><ERROR>mapscript_csharp<br/>msOracleSpatialLayerWhichShapes():
OracleSpatial error. Error: ORA-00933: SQL command not properly ended<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> . Query statement: SELECT OBJECTID, OBJECTID, shape
FROM (SELECT shape, NAMN, OBJECTID FROM SDO_KOMMUN) WHERE OBJECTID
= OBJECTID = 75 AND SDO_FILTER( shape, MDSYS.SDO_GEOMETRY(2003,
NULL,
NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),MDSYS.SDO_ORDINATE_ARRAY(1194973,6083188,1973312,7687503)
),'querytype=window') = 'TRUE' . Check your data statement.</ERROR><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Look at the where statement: <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>WHERE OBJECTID = OBJECTID = 75 <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hmmm<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I couldn’t se other than I send in the correct string
but something happens. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>My mapfile look like this:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> LAYER<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> NAME SDO_KOMMUN_O<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> TYPE POLYGON<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> STATUS ON<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> CONNECTION
"wmgis/wmgis01@wmsi1394"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> CONNECTIONTYPE oraclespatial <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> DATA "shape FROM (SELECT shape,
NAMN, OBJECTID FROM SDO_KOMMUN) USING UNIQUE OBJECTID VERSION 10g" <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> TEMPLATE "c:\temp\template.txt"<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> DEBUG on<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> CLASS<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> OUTLINECOLOR 0 0 255<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> COLOR 100 100 255<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> END<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> END<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’m using mapcript in the csharp environment.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Is there any change here in new 5.0 release?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>/Johan<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<h3 style='margin:0cm;margin-bottom:.0001pt'><b><font size=2 face=Arial><span
lang=SV style='font-size:10.0pt;font-family:Arial'>___________________________________</span></font></b><font
face=Arial><span lang=SV style='font-family:Arial'><o:p></o:p></span></font></h3>
<h3 style='margin:0cm;margin-bottom:.0001pt'><b><font size=3 face=Arial><span
lang=SV style='font-size:12.0pt;font-family:Arial'>Johan Hallgren</span></font></b><font
face=Arial><span lang=SV style='font-family:Arial'><o:p></o:p></span></font></h3>
<div>
<p class=MsoNormal><font size=2 face=Arial><span lang=SV style='font-size:10.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 face=Arial><span lang=SV style='font-size:9.0pt;
font-family:Arial'>WM-data, Logica CMG</span></font><font size=2 face=Arial><span
lang=SV style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 face=Arial><span lang=SV style='font-size:9.0pt;
font-family:Arial'>Pelle Bergs backe 3</span></font><font size=2 face=Arial><span
lang=SV style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 face=Arial><span lang=SV style='font-size:9.0pt;
font-family:Arial'>Box 1938, 791 19 Falun</span></font><font size=2
face=Arial><span lang=SV style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<div>
<p class=MsoNormal><font size=1 face=Arial><span lang=SV style='font-size:9.0pt;
font-family:Arial'>Tel (och mobil): 023-547 46 (int: +46-2354746)</span></font><font
size=2 face=Arial><span lang=SV style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><u><font size=1 color=blue face=Arial><span lang=SV
style='font-size:9.0pt;font-family:Arial;color:blue'>johan.e.hallgren</span></font></u><a
href="blocked::mailto:johan.e.hallgren@wmdata.com" target="_blank"
title="blocked::mailto:johan.e.hallgren@wmdata.com"><font size=1 face=Arial><span
lang=SV style='font-size:9.0pt;font-family:Arial'>@wmdata.com</span></font></a><font
size=2 face=Arial><span lang=SV style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><a
href="blocked::https://webaccess.wmdata.com/exchweb/bin/redir.asp?URL=http://www.wmdata.se/"
target="_blank"
title="blocked::https://webaccess.wmdata.com/exchweb/bin/redir.asp?URL=http://www.wmdata.se/"><font
size=1 face=Arial><span lang=SV style='font-size:9.0pt;font-family:Arial'>http://www.wmdata.se</span></font></a></span></font><font
size=2 face=Arial><span lang=SV style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span lang=SV
style='font-size:12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>