<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:st1="urn:schemas-microsoft-com:office:smarttags" 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)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="PersonName"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@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;
font-family:Verdana;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:Verdana;
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@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 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I think I found the error myself<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I have to have the “USING UNIQUE objected”
in the string, otherwise the functions will return wrong </span></font><font
size=2 face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New"'>shapeindex.</span></font><font
size=2 color=blue face=Verdana><span style='font-size:10.0pt;font-family:Verdana;
color:blue'><o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>I also have to place the NONE parameter
at the correct place in the string (NONE tells mapserver to not use any Spatial
operator and it will be fast when querying). As I have found out, the datastring
should be </span></font><font size=2 face="Courier New"><span style='font-size:
10.0pt;font-family:"Courier New"'>USING UNIQUE objectid NONE VERSION 10g</span></font><font
size=2 color=blue face=Verdana><span style='font-size:10.0pt;font-family:Verdana;
color:blue'> when doing QueryByAttribute with good performance.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>The only change I should prefer here is
to change the OracleSpatial interface so the order wasn’t so important. Why
not “</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>USING UNIQUE objectid FUNCTION
NONE VERSION 10g”</span></font><font size=2 color=blue face=Verdana><span
style='font-size:10.0pt;font-family:Verdana;color:blue'> <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=blue face=Verdana><span style='font-size:
10.0pt;font-family:Verdana;color:blue'>/Johan<o:p></o:p></span></font></p>
<div>
<h3 style='margin:0cm;margin-bottom:.0001pt'><b><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'>___________________________________</span></font></b><font
color=blue face=Arial><span style='font-family:Arial;color:blue'><o:p></o:p></span></font></h3>
<h3 style='margin:0cm;margin-bottom:.0001pt'><b><font size=3 color=blue
face=Arial><span style='font-size:12.0pt;font-family:Arial;color:blue'>Johan
Hallgren</span></font></b><font color=blue face=Arial><span style='font-family:
Arial;color:blue'><o:p></o:p></span></font></h3>
<div>
<p class=MsoNormal><font size=2 color=blue face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:blue'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><b><font size=2 color=gray face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:gray;font-weight:bold'>WM-data</span></font></b><font
size=2 color=gray face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:gray'> a LogicaCMG company </span></font><font size=2 color=blue
face=Arial><span style='font-size:10.0pt;font-family:Arial;color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=blue face=Arial><span lang=SV
style='font-size:9.0pt;font-family:Arial;color:blue'>Pelle Bergs backe 3</span></font><font
size=2 color=blue face=Arial><span lang=SV style='font-size:10.0pt;font-family:
Arial;color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=blue face=Arial><span lang=SV
style='font-size:9.0pt;font-family:Arial;color:blue'>Box 1938, 791 19
Falun</span></font><font size=2 color=blue face=Arial><span lang=SV
style='font-size:10.0pt;font-family:Arial;color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<div>
<p class=MsoNormal><font size=1 color=blue face=Arial><span lang=SV
style='font-size:9.0pt;font-family:Arial;color:blue'>Tel: 023-547 46 (int:
+46-2354746)<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=1 color=blue face=Arial><span lang=SV
style='font-size:9.0pt;font-family:Arial;color:blue'>Mobil: 070-588 44
28 (int: +46-705884428)</span></font><font size=2 color=blue face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:blue'><o:p></o:p></span></font></p>
</div>
<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><font
size=1 color=blue face=Arial><span lang=SV style='font-size:9.0pt;font-family:
Arial;color:blue'><a href="BLOCKED::mailto:johan.e.hallgren@wmdata.com"
target="_blank" title="mailto:johan.e.hallgren@wmdata.com">@wmdata.com</a></span></font><font
size=2 color=blue face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:blue'><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=blue face=Arial><span lang=SV
style='font-size:9.0pt;font-family:Arial;color:blue'><a
href="BLOCKED::/exchweb/bin/redir.asp?URL=http://www.wmdata.se/" target="_blank"
title="/exchweb/bin/redir.asp?URL=http://www.wmdata.se/">http://www.wmdata.se</a></span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
</div>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> UMN MapServer
Developers List [mailto:MAPSERVER-DEV@LISTS.UMN.EDU] <b><span style='font-weight:
bold'>On Behalf Of </span></b><st1:PersonName w:st="on">Hallgren Johan E</st1:PersonName><br>
<b><span style='font-weight:bold'>Sent:</span></b> den 30 mars 2007 22:40<br>
<b><span style='font-weight:bold'>To:</span></b> MAPSERVER-DEV@LISTS.UMN.EDU<br>
<b><span style='font-weight:bold'>Subject:</span></b> [UMN_MAPSERVER-DEV] More
OracleSpatial queryByAttributes</span></font><o:p></o:p></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>
<p class=MsoNormal><font size=2 face=Verdana><span style='font-size:10.0pt;
font-family:Verdana'>I have tested more to isolate the problem. <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 style='font-size:10.0pt;
font-family:Verdana'>Here is the MapFile<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> LAYER<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> NAME
SDOLayer<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> TYPE
POLYGON<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> STATUS
OFF<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
CONNECTION "user/pwd@tnsname"<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
CONNECTIONTYPE oraclespatial <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
DATA "shape FROM SDOLayer USING UNIQUE objectid VERSION 10g" <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> TEMPLATE
"c:\temp\template.txt"<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
STATUS DEFAULT<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
MAXSCALE 150000<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
DEBUG ON<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> CLASS<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
STYLE<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
OUTLINECOLOR 0 0 255<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
COLOR 255 0 0<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
END<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> END<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> END<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 style='font-size:10.0pt;
font-family:Verdana'><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 style='font-size:10.0pt;
font-family:Verdana'>Here is a samplecode.<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color="#2b91af"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#2B91AF'>mapObj</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> mapObj = <font color=blue><span
style='color:blue'>new</span></font> <font color="#2b91af"><span
style='color:#2B91AF'>mapObj</span></font>(<font color="#a31515"><span
style='color:#A31515'>@"C:\Project\applications\GMS\GMSAgent\MapFiles\Map.map"</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color="#2b91af"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#2B91AF'>layerObj</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> oLayerObj =
mapObj.getLayerByName(<font color="#a31515"><span style='color:#A31515'>"SDOLayer"</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span lang=SV style='font-size:10.0pt;font-family:"Courier New";
color:blue'>string</span></font><font size=2 face="Courier New"><span lang=SV
style='font-size:10.0pt;font-family:"Courier New"'> orgDataStr =
oLayerObj.data;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span lang=SV style='font-size:10.0pt;font-family:"Courier New";
color:blue'>string</span></font><font size=2 face="Courier New"><span lang=SV
style='font-size:10.0pt;font-family:"Courier New"'> tmpDataStr =
oLayerObj.data;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>int</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> iUsingLocation =
tmpDataStr.LastIndexOf(<font color="#a31515"><span style='color:#A31515'>"
USING "</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>if</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> (iUsingLocation > 0)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> tmpDataStr =
orgDataStr.Substring(0, iUsingLocation);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>tmpDataStr += <font
color="#a31515"><span style='color:#A31515'>" USING NONE"</span></font>;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>// CREATE ERROR.<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>// This is used to speed up
the query, no spatial operator will be used. <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>oLayerObj.data = tmpDataStr;<font
color=green><span style='color:green'><o:p></o:p></span></font></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=green
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:green'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>string</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> strFld = <font
color="#a31515"><span style='color:#A31515'>"OBJECTID"</span></font>;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>string</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> strWhere = <font
color="#a31515"><span style='color:#A31515'>"OBJECTID = 2000"</span></font>;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>oLayerObj.queryByAttributes(mapObj,
strFld, strWhere, <font color="#2b91af"><span style='color:#2B91AF'>mapscript</span></font>.MS_MULTIPLE);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>oLayerObj.data = orgDataStr;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color="#2b91af"
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:#2B91AF'>resultCacheObj</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> oResultCacheObj =
oLayerObj.getResults();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 color=blue
face="Courier New"><span style='font-size:10.0pt;font-family:"Courier New";
color:blue'>if</span></font><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> (oResultCacheObj.numresults
> 0)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>{<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>int</span></font> lFeat = 0;<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> oLayerObj.open();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font color=blue><span
style='color:blue'>for</span></font> (lFeat = 0; lFeat <
oResultCacheObj.numresults; lFeat++)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> {<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color="#2b91af"><span style='color:#2B91AF'>resultCacheMemberObj</span></font>
oResultCacheMemberObj = oResultCacheObj.getResult(lFeat);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> // ERROR
- ERROR - ERROR - ERROR - ERROR - ERROR - ERROR - ERROR - ERROR - ERROR<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> // HERE
IS THE ERROR. <o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> //
oResultCacheMemberObj.shapeindex will always return the first record. If the
oLayerObj.data<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> // is not
changed, the result is correct but the perforamce is terrible.<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color="#2b91af"><span style='color:#2B91AF'>shapeObj</span></font> oShapeObj =
oLayerObj.getFeature(oResultCacheMemberObj.shapeindex,
oResultCacheMemberObj.tileindex);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> <font
color=blue><span style='color:blue'>for</span></font> (<font color=blue><span
style='color:blue'>int</span></font> item = 0; item < oLayerObj.numitems;
item++)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> {<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
<font color=blue><span style='color:blue'>string</span></font>
strUFldName = oLayerObj.getItem(item).ToUpper();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
<font color=blue><span style='color:blue'>if</span></font>
(strUFldName != <font color="#a31515"><span style='color:#A31515'>"SHAPE"</span></font>)<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
{<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
<font color=blue><span style='color:blue'>string</span></font>
strVal = oShapeObj.getValue(item);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
System.Diagnostics.<font color="#2b91af"><span
style='color:#2B91AF'>Debug</span></font>.Write(strUFldName + <font
color="#a31515"><span style='color:#A31515'>"="</span></font> +
strVal + <font color="#a31515"><span style='color:#A31515'>", "</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
}<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'><o:p> </o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> }<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
System.Diagnostics.<font color="#2b91af"><span style='color:#2B91AF'>Debug</span></font>.Write(<font
color="#2b91af"><span style='color:#2B91AF'>Environment</span></font>.NewLine);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>
System.Diagnostics.<font color="#2b91af"><span style='color:#2B91AF'>Debug</span></font>.WriteLine(<font
color="#a31515"><span style='color:#A31515'>"-------------------"</span></font>);<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> }<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> oLayerObj.close();<o:p></o:p></span></font></p>
<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>}<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>
<h3 style='margin:0cm;margin-bottom:.0001pt'><b><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>___________________________________</span></font></b><font
face=Arial><span 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
style='font-size:12.0pt;font-family:Arial'>Johan Hallgren</span></font></b><font
face=Arial><span style='font-family:Arial'><o:p></o:p></span></font></h3>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> <o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><b><font size=2 color=gray face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:gray;font-weight:bold'>WM-data</span></font></b><font
size=2 color=gray face=Arial><span style='font-size:10.0pt;font-family:Arial;
color:gray'> a LogicaCMG company </span></font><font size=2 face=Arial><span
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: 023-547 46 (int: +46-2354746)<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal><font size=1 face=Arial><span lang=SV style='font-size:9.0pt;
font-family:Arial'>Mobil: 070-588 44 28 (int: +46-705884428)</span></font><font
size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
</div>
<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><font
size=1 face=Arial><span lang=SV style='font-size:9.0pt;font-family:Arial'><a
href="BLOCKED::mailto:johan.e.hallgren@wmdata.com" target="_blank"
title="mailto:johan.e.hallgren@wmdata.com">@wmdata.com</a></span></font><font
size=2 face=Arial><span 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'><a
href="BLOCKED::/exchweb/bin/redir.asp?URL=http://www.wmdata.se/" target="_blank"
title="/exchweb/bin/redir.asp?URL=http://www.wmdata.se/">http://www.wmdata.se</a></span></font><font
size=2 face=Arial><span 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 style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
</body>
</html>