<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Johan,<br>
Sorry for the delay to reply your message. My internet provider just
turn on the DSL link this weekend in my new home, and I couldn't read
my e-mail from a week.<br>
About the error, I will investigate more about the source of the
error and analyze the solutions (inclusive yours).<br>
Sorry again for the delay.<br>
Best regards.<br>
<br>
Fernando Simon<br>
<br>
<br>
Hallgren Johan E wrote:
<blockquote
cite="midD93CFEAA72FA764885CC1FDA94A1D89C02904D2E@WMRI000166.corp.wmdata.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<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]-->
</o:SmartTagType>
<div class="Section1">
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;">I think I
found the error myself<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; 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
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">shapeindex.</span></font><font
color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;"><o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; 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 face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">USING UNIQUE
objectid NONE VERSION 10g</span></font><font color="blue" face="Verdana"
size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;"> when
doing QueryByAttribute with good performance.<o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; 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 face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">USING UNIQUE
objectid FUNCTION
NONE VERSION 10g”</span></font><font color="blue" face="Verdana"
size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;"> <o:p></o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font color="blue" face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana; color: blue;">/Johan<o:p></o:p></span></font></p>
<div>
<h3 style="margin: 0cm 0cm 0.0001pt;"><b><font color="blue"
face="Arial" size="2"><span
style="font-size: 10pt; 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 0cm 0.0001pt;"><b><font color="blue"
face="Arial" size="3"><span
style="font-size: 12pt; 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 color="blue" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: blue;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><b><font color="gray" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: gray; font-weight: bold;">WM-data</span></font></b><font
color="gray" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: gray;"> a LogicaCMG
company </span></font><font color="blue" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV">Pelle
Bergs backe 3</span></font><font color="blue" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: blue;" lang="SV"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV">Box
1938, 791 19
Falun</span></font><font color="blue" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: blue;" lang="SV"><o:p></o:p></span></font></p>
</div>
<div>
<div>
<p class="MsoNormal"><font color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV">Tel:
023-547 46 (int:
+46-2354746)<o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV">Mobil:
070-588 44
28 (int: +46-705884428)</span></font><font color="blue" face="Arial"
size="2"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><u><font color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV">johan.e.hallgren</span></font></u><font
color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV"><a
href="BLOCKED::mailto:johan.e.hallgren@wmdata.com" target="_blank"
title="mailto:johan.e.hallgren@wmdata.com">@wmdata.com</a></span></font><font
color="blue" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: blue;"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV"><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
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span></font></p>
</div>
</div>
<div>
<div class="MsoNormal" style="text-align: center;" align="center"><font
face="Times New Roman" size="3"><span style="font-size: 12pt;">
<hr tabindex="-1" align="center" size="2" width="100%"></span></font></div>
<p class="MsoNormal"><b><font face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma; font-weight: bold;">From:</span></font></b><font
face="Tahoma" size="2"><span
style="font-size: 10pt; font-family: Tahoma;"> UMN MapServer
Developers List [<a class="moz-txt-link-freetext" href="mailto:MAPSERVER-DEV@LISTS.UMN.EDU">mailto:MAPSERVER-DEV@LISTS.UMN.EDU</a>] <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>
<a class="moz-txt-link-abbreviated" href="mailto:MAPSERVER-DEV@LISTS.UMN.EDU">MAPSERVER-DEV@LISTS.UMN.EDU</a><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 face="Times New Roman" size="3"><span
style="font-size: 12pt;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">I have tested more to
isolate the problem. <o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Here is the MapFile<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> LAYER<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> NAME
SDOLayer<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> TYPE
POLYGON<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> STATUS
OFF<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
CONNECTION "user/pwd@tnsname"<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
CONNECTIONTYPE oraclespatial <o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
DATA "shape FROM SDOLayer USING UNIQUE objectid VERSION 10g" <o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> TEMPLATE
"c:\temp\template.txt"<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
STATUS DEFAULT<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
MAXSCALE 150000<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
DEBUG ON<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> CLASS<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
STYLE<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
OUTLINECOLOR 0 0 255<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
COLOR 255 0 0<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
END<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> END<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> END<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;">Here is a samplecode.<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="#2b91af" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: rgb(43, 145, 175);">mapObj</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> mapObj = <font
color="blue"><span style="color: blue;">new</span></font> <font
color="#2b91af"><span style="color: rgb(43, 145, 175);">mapObj</span></font>(<font
color="#a31515"><span style="color: rgb(163, 21, 21);">@"C:\Project\applications\GMS\GMSAgent\MapFiles\Map.map"</span></font>);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="#2b91af" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: rgb(43, 145, 175);">layerObj</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> oLayerObj =
mapObj.getLayerByName(<font color="#a31515"><span
style="color: rgb(163, 21, 21);">"SDOLayer"</span></font>);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font color="blue" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: blue;"
lang="SV">string</span></font><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";" lang="SV">
orgDataStr =
oLayerObj.data;<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="blue" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: blue;"
lang="SV">string</span></font><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";" lang="SV">
tmpDataStr =
oLayerObj.data;<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="blue" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: blue;">int</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> iUsingLocation =
tmpDataStr.LastIndexOf(<font color="#a31515"><span
style="color: rgb(163, 21, 21);">"
USING "</span></font>);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="blue" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: blue;">if</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> (iUsingLocation
> 0)<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> tmpDataStr =
orgDataStr.Substring(0, iUsingLocation);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">tmpDataStr += <font
color="#a31515"><span style="color: rgb(163, 21, 21);">" USING NONE"</span></font>;<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">// CREATE ERROR.<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font color="green" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: green;"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font color="blue" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: blue;">string</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> strFld = <font
color="#a31515"><span style="color: rgb(163, 21, 21);">"OBJECTID"</span></font>;<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="blue" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: blue;">string</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> strWhere = <font
color="#a31515"><span style="color: rgb(163, 21, 21);">"OBJECTID =
2000"</span></font>;<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">oLayerObj.queryByAttributes(mapObj,
strFld, strWhere, <font color="#2b91af"><span
style="color: rgb(43, 145, 175);">mapscript</span></font>.MS_MULTIPLE);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">oLayerObj.data =
orgDataStr;<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="#2b91af" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: rgb(43, 145, 175);">resultCacheObj</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> oResultCacheObj
=
oLayerObj.getResults();<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font color="blue" face="Courier New"
size="2"><span
style="font-size: 10pt; font-family: "Courier New"; color: blue;">if</span></font><font
face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
(oResultCacheObj.numresults
> 0)<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">{<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
oLayerObj.open();<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> {<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> <font
color="#2b91af"><span style="color: rgb(43, 145, 175);">resultCacheMemberObj</span></font>
oResultCacheMemberObj = oResultCacheObj.getResult(lFeat);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> // HERE
IS THE ERROR. <o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> <font
color="#2b91af"><span style="color: rgb(43, 145, 175);">shapeObj</span></font>
oShapeObj =
oLayerObj.getFeature(oResultCacheMemberObj.shapeindex,
oResultCacheMemberObj.tileindex);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> {<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
<font color="blue"><span style="color: blue;">if</span></font>
(strUFldName != <font color="#a31515"><span
style="color: rgb(163, 21, 21);">"SHAPE"</span></font>)<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
{<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; 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=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
System.Diagnostics.<font color="#2b91af"><span
style="color: rgb(43, 145, 175);">Debug</span></font>.Write(strUFldName
+ <font color="#a31515"><span style="color: rgb(163, 21, 21);">"="</span></font>
+
strVal + <font color="#a31515"><span style="color: rgb(163, 21, 21);">",
"</span></font>);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
}<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"><o:p> </o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> }<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
System.Diagnostics.<font color="#2b91af"><span
style="color: rgb(43, 145, 175);">Debug</span></font>.Write(<font
color="#2b91af"><span style="color: rgb(43, 145, 175);">Environment</span></font>.NewLine);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
System.Diagnostics.<font color="#2b91af"><span
style="color: rgb(43, 145, 175);">Debug</span></font>.WriteLine(<font
color="#a31515"><span style="color: rgb(163, 21, 21);">"-------------------"</span></font>);<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";"> }<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">
oLayerObj.close();<o:p></o:p></span></font></p>
<p class="MsoNormal" style=""><font face="Courier New" size="2"><span
style="font-size: 10pt; font-family: "Courier New";">}<o:p></o:p></span></font></p>
<p class="MsoNormal"><font face="Verdana" size="2"><span
style="font-size: 10pt; font-family: Verdana;"><o:p> </o:p></span></font></p>
<h3 style="margin: 0cm 0cm 0.0001pt;"><b><font face="Arial" size="2"><span
style="font-size: 10pt; 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 0cm 0.0001pt;"><b><font face="Arial" size="3"><span
style="font-size: 12pt; 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 face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"> <o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><b><font color="gray" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: gray; font-weight: bold;">WM-data</span></font></b><font
color="gray" face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial; color: gray;"> a LogicaCMG
company </span></font><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial;" lang="SV">Pelle Bergs
backe 3</span></font><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="SV"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial;" lang="SV">Box 1938, 791 19
Falun</span></font><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;" lang="SV"><o:p></o:p></span></font></p>
</div>
<div>
<div>
<p class="MsoNormal"><font face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial;" lang="SV">Tel: 023-547 46
(int: +46-2354746)<o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial;" lang="SV">Mobil: 070-588
44 28 (int: +46-705884428)</span></font><font face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><u><font color="blue" face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial; color: blue;" lang="SV">johan.e.hallgren</span></font></u><font
face="Arial" size="1"><span style="font-size: 9pt; font-family: Arial;"
lang="SV"><a href="BLOCKED::mailto:johan.e.hallgren@wmdata.com"
target="_blank" title="mailto:johan.e.hallgren@wmdata.com">@wmdata.com</a></span></font><font
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span></font></p>
</div>
<div>
<p class="MsoNormal"><font face="Arial" size="1"><span
style="font-size: 9pt; font-family: Arial;" lang="SV"><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
face="Arial" size="2"><span
style="font-size: 10pt; font-family: Arial;"><o:p></o:p></span></font></p>
</div>
<p class="MsoNormal"><font face="Times New Roman" size="3"><span
style="font-size: 12pt;"><o:p> </o:p></span></font></p>
</div>
</blockquote>
<br>
</body>
</html>