<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><div>File this as a bug I think I know what's happening...</div><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><br><div style="font-family:times new roman, new york, times, serif;font-size:12pt"><font size="2" face="Tahoma"><b><span style="font-weight: bold;">From:</span></b> "Reynolds, Michael J. (DOT)" <Mike.Reynolds@state.mn.us><br><b><span style="font-weight: bold;">To:</span></b> "geomoose-users@lists.sourceforge.net" <geomoose-users@lists.sourceforge.net><br><b><span style="font-weight: bold;">Sent:</span></b> Mon, March 29, 2010 10:01:27 AM<br><b><span style="font-weight: bold;">Subject:</span></b> [Geomoose-users] OGR mdb pgdb query issue<br></font><br>
<style>
<!--
_filtered {font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
_filtered {font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"serif";}
a:link, span.MsoHyperlink
{
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{
color:purple;
text-decoration:underline;}
p
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"serif";}
p.ecxmsonormal, li.ecxmsonormal, div.ecxmsonormal
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"serif";}
p.ecxmsoplaintext, li.ecxmsoplaintext, div.ecxmsoplaintext
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"serif";}
p.ecxmsoautosig, li.ecxmsoautosig, div.ecxmsoautosig
{
margin-right:0in;
margin-left:0in;
font-size:12.0pt;
font-family:"serif";}
p.ecxmsonormal1, li.ecxmsonormal1, div.ecxmsonormal1
{
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"serif";}
p.ecxmsoplaintext1, li.ecxmsoplaintext1, div.ecxmsoplaintext1
{
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.ecxmsoautosig1, li.ecxmsoautosig1, div.ecxmsoautosig1
{
margin-right:0in;
margin-bottom:0in;
margin-left:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"serif";}
p.msochpdefault, li.msochpdefault, div.msochpdefault
{
margin-right:0in;
margin-left:0in;
font-size:10.0pt;
font-family:"serif";}
span.ecxmsohyperlink1
{
color:blue;
text-decoration:underline;}
span.ecxmsohyperlinkfollowed1
{
color:purple;
text-decoration:underline;}
span.ecxemailstyle171
{
font-family:"sans-serif";
color:windowtext;}
span.emailstyle30
{
font-family:"sans-serif";
color:#1F497D;}
span.EmailStyle29
{
font-family:"sans-serif";
color:#1F497D;}
.MsoChpDefault
{
font-size:10.0pt;}
_filtered {
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{}
-->
</style>
<div class="Section1">
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">I
have a map file at: </span><span style="font-family:"sans-serif";
color:black;">/ms4w/apps/metrogis/maps/mapfiles_metro/assets/signs/signing_striping_ora.map</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;"> </span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">In
it I have two layers. The connection settings for each are as follows:</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
…</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
NAME 'Cantilevers'</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
CONNECTIONTYPE ogr</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
CONNECTION '\\ad\metro\roseville\data\traffic\gis\mte.mdb'</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
DATA 'OH_SGNS'</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
…</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;"> </span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
…</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
NAME 'SignTrack'</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
CONNECTIONTYPE oraclespatial</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
CONNECTION "ags_signtrack/ags_signtrack@tgp"</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
DATA "SHAPE FROM (SELECT SHAPE, CODE || '|' || MARKER as LBL, OBJECTID,
INVENTORYID, SUPPORTID, DESCRIPTION, SIGNLIBRARYID, CODE, MARKER FROM
SIGNTRACK_ADMIN.SIGN_FIELD_INVENTORY) USING UNIQUE OBJECTID"</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">
…</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;"> </span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">Both
are ‘hooked in’ and render fine when each layer is turned on specifically or as
addressed as All.</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;"> </span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">Both
identify correctly.</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;"> </span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">With
a query service I created I get the following error:</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;"> </span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">Warning</span><span style="font-family:"sans-serif";color:black;">: [MapServer Error]:
msShapefileOpen():
(/ms4w/apps/metrogis/maps/mapfiles_metro/assets/signs/OH_SGNS) in C:\ms4w\apps\metrogis\htdocs\php\query.php
on line 320<br>
<br>
Warning: [MapServer Error]: msShapefileOpen(): (/ms4w/apps/metrogis/maps/mapfiles_metro/assets/signs/OH_SGNS)
in C:\ms4w\apps\metrogis\htdocs\php\query.php on line 320<br>
<br>
Fatal error: Object expected as argument. in C:\ms4w\apps\metrogis\htdocs\php\query.php
on line 320</span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;"> </span></p>
<p class="MsoNormal"><span style="font-family:"sans-serif";color:black;">What
I notice is that the map file path has been prefixed to the DATA value and that
it may be causing an error in the msShapefileOpen() method. I’ve debugged
through the query.php but I don’t think I’m familiar enough with the mapserver
objects and the query.php to understand where or why its getting mixed up.</span><span style="font-family:"sans-serif";color:black;"> </span></p>
</div>
</div></div></blockquote><div style="position:fixed"></div>
</div><br>
</body></html>