<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>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p
{mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</style>
</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'>I want to query an SDE layer by two fields…is there
documentation on the format required?<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 code looks something like:<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'> if($layer->queryByAttributes("(field1,field2)",
"([ field1]=$field1 and [field2]=1", MS_MULTIPLE)==MS_SUCCESS){<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> $numRes =
$layer->getNumResults();<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->open();<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> for($k=0;$k<$numRes;$k++){<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> $res =
$layer->getResult($k);<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> $shape =
$layer->getShape($res->tileindex, $res->shapeindex); <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> // do something<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'> } <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'>And I’m getting an error that looks like:<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 style='text-indent:.5in'><font size=3 face="Times New Roman"><span
style='font-size:12.0pt'>[MapServer Error]: msSDELayerInitItemInfo(): A
specified CLASSITEM, FILTERITEM, or expression key cannot be found in c:\...<o:p></o:p></span></font></p>
<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=Arial><span style='font-size:10.0pt;
font-family:Arial'>Sorry if this is an obvious thing. I usually take more time
to explore but I have a deadline looming. <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'>PHP 5.2.4<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>MapServer version 5.0 from latest MS4W<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Windows server 2003<o:p></o:p></span></font></p>
<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=3 face="Times New Roman"><span style='font-size:
12.0pt'>Thanks, </span></font><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'><o:p></o:p></span></font></p>
<p><st1:PersonName w:st="on"><font size=2 face=Arial><span style='font-size:
10.0pt;font-family:Arial'>Josh Hevenor</span></font></st1:PersonName><br>
<font size=2 face=Arial><span style='font-size:10.0pt;font-family:Arial'>Application
Developer<br>
</span></font><font size=1 face=Arial><span style='font-size:7.5pt;font-family:
Arial'>____________________________________________<br>
5230 South Service Road<br>
<U1:CITY u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"><U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0">Burlington</U1:PLACE></U1:CITY>,
Ontario <br>
L7L 5K2 <U1:COUNTRY-REGION u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z"><U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0">Canada</U1:PLACE></U1:COUNTRY-REGION><br>
<strong><b><font face=Arial><span style='font-family:Arial;font-weight:normal'><U1:ADDRESS u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0"><U1:COUNTRY-REGION u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z"><U1:PLACE u2:insAuthor="Robert Murodch" u2:insDate="2005-12-19T11:22:00Z" u2:endInsAuthor="Robert Murodch" u2:endInsDate="2005-12-19T11:22:00Z" ns1:style="BACKGROUND-POSITION: left bottom; BACKGROUND-IMAGE: url(res://ietag.dll/#34/#1001); BACKGROUND-REPEAT: repeat-x" ns1:tabIndex="0">Email:
josh.hevenor@dpra.com</span></font></b></strong></span></font><b><font size=2
face=Arial><span style='font-size:10.0pt;font-family:Arial;font-weight:bold'><br>
</span></font></b><font size=1 face=Arial><span style='font-size:7.5pt;
font-family:Arial'>Internet: http://www.dpra.com</span></font><b><span
style='font-weight:bold'><br>
</span></b><font size=2 face=Arial><span style='font-size:10.0pt;font-family:
Arial'><img width=150 height=43 id="_x0000_i1025"
src="cid:image001.jpg@01C857A2.F8867920" border=0><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'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><br>
</span></font><strong><b><font size=2 color=silver face=Arial><span
style='font-size:10.0pt;font-family:Arial;color:silver'>Attention:</span></font></b></strong><b><font
size=2 color=silver><span style='font-size:10.0pt;color:silver;font-weight:
bold'><br>
</span></font></b><font size=2 color=silver><span style='font-size:10.0pt;
color:silver'>Privileged/Confidential Information may be contained in this
message. Disclosure to any person other than the named recipient is
unauthorized. If you are not the intended recipient, please delete all copies
of this information and kindly notify the sender by reply email. Opinions,
conclusions and other information in this message that do not relate to the
official business of DPRA shall be understood as neither given nor endorsed by
it. DPRA and any of its subsidiaries reserve the right to monitor all e-mail
communications through its networks. Thank you.<o:p></o:p></span></font></p>
<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>