<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Michael,<br>
<br>
It sounds like Mapserver (or OGR?) can't find the SYSTEM_ID
field. How are you specifying which table in the database to use
(what's your DATA object in the mapfile look like?<br>
<pre class="moz-signature" cols="72">Best Regards,
Brent Fraser</pre>
<br>
On 11/15/2011 6:32 AM, Reynolds, Michael J. (DOT) wrote:
<blockquote
cite="mid:6E5F1F66B0B9D8489AED04F46BA564BC03F1C2@055-CH1MPN1-001.055d.mgd.msft.net"
type="cite">
<meta http-equiv="Content-Type" content="text/html;
charset=ISO-8859-1">
<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]-->
<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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Geomoose-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Geomoose-users@lists.osgeo.org">Geomoose-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/geomoose-users">http://lists.osgeo.org/mailman/listinfo/geomoose-users</a>
</pre>
</blockquote>
</body>
</html>