<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:m="http://schemas.microsoft.com/office/2004/12/omml" 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 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></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="WordSection1">
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I’m having trouble with the Geomoose 2.4 query.php, ms4w 3.0.3 (mapserver 6.0.1) and a personal geodatabase (pgdb ms access mdb esri).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">I think I have it narrowed down to an issue with the setFilter or the $filter_string.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">If I comment out $queryLayer->setFilter($filter_string); at about line 300 then the Search By runs and returns ALL features using the template. Proves template is good, map file is good, connection
is possible to the data (mapserver ogr mapscript pgdb working together ok).<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">My map file is very simple for testing purposes:<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;color:black">CONNECTIONTYPE OGR<o:p></o:p></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:12.0pt;color:black"> CONNECTION 'mte_systems.mdb'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"> DATA "SIGNAL_SYSTEMS"<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">No class items or expressions.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">The filter query.php builds is $filter_string = upper(SYSTEM_ID) like '%'||upper('27')||'%'<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">The field SYSTEM_ID is all capital in the database (matters?). The SYSTEM_ID field is a number data type.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">MS debug is active and reports the following when the setFilter line is active:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">[Tue Nov 15 07:25:17 2011].25000 getSymbol(): Symbol definition error. Parsing error near (upper):(line 228)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">[Tue Nov 15 07:25:17 2011].695000 msEvalExpression(): General error message. Cannot evaluate expression, no item index defined.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">… repeat above line equal number of times to the number of all features in the feature class …<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">[Tue Nov 15 07:25:17 2011].788000 msQueryByRect(): Search returned no results. No matching record(s) found.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">[Tue Nov 15 07:25:18 2011].116000 msFreeMap(): freeing map at 036B6A18.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Not sure what Item Index might be referring too. The PGDB has an OBJECTID field.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:12.0pt;color:black">Any suggestions on what to fiddle with next?<o:p></o:p></span></p>
</div>
</body>
</html>