[Geomoose-users] PGDB mdb query.php
Len Kne
lkne at houstoneng.com
Mon Jul 12 14:59:01 EDT 2010
I've not tried using a PGDB in the query service, but a couple things to try:
1. Comment out error_reporting(E_ERROR | E_PARSE); to see if more warning messages are popping up
2. Try removing the "All" layer name from the map-source since you have the layers defined below it.
Len
-----Original Message-----
From: Reynolds, Michael J. (DOT) [mailto:Mike.Reynolds at state.mn.us]
Sent: Sunday, July 11, 2010 4:39 PM
To: geomoose-users at lists.sourceforge.net
Subject: [Geomoose-users] PGDB mdb query.php
Wondering if any users can confirm or deny that a search tool using query.php and a map file with a data connection to a personal geodatabase (.mdb) will work.
I'm using GeoMoose 2.0.
I'm struggling to set this search tool up in my environment.
The layer's map file settings are:
NAME 'Cabinets'
CONNECTIONTYPE ogr
CONNECTION '\\ad\metro\roseville\data\traffic\gis\mte_systems.mdb'
DATA "SELECT OBJECTID, SHAPE, SYSTEM_ID, CABINET_ID, LAYOUT_URL, CABINET_TYPE, CABINET_VOLTS, ROADWAY_NAME, LOCATION, QUAD, METER_VENDOR, METER_ACCOUNT, METER_ADDRESS, METER_NBR, PREMISE_NBR, OWNER_CODE, SHARED_POWER_CSV, format(DATE_LOGGED,'mm/dd/yyyy') AS CDATE_LOGGED, format(DATE_INSTALLED, 'mm/dd/yyyy') AS CDATE_INSTALLED, format(DATE_TURNON, 'mm/dd/yyyy') AS CDATE_TURNON, format(DATE_RETIRED, 'mm/dd/yyyy') AS CDATE_RETIRED, GEOMSRC_CODE FROM LIGHT_CABINETS WHERE (DATE_TURNON < date() OR DATE_TURNON Is NULL) AND (DATE_RETIRED > date() OR DATE_RETIRED Is NULL)"
The mapfile <map-source> entry is:
<map-source name="traffic_lighting_systems_pgdb" type="mapserver" reference="false">
<file>/ms4w/apps/metrogis/maps/mapfiles_metro/assets/traffic_lighting_systems_pgdb.map</file>
<layer name="all"/>
<layer name="Poles"/>
<layer name="Cabinets"/>
<layer name="Utilities"/>
<layer name="Junctions"/>
<layer name="PowerSources"/>
</map-source>
Note that this layer
The <Service> is:
<service name="search_lighting_cabinet">
<url>php/query.php</url>
<step type="input">
<input type="hidden" name="highlight" value="true"/>
<input type="hidden" name="mode" value="search"/>
<input type="hidden" name="layer0" value="traffic_lighting_systems_pgdb/Cabinets"/>
<input type="hidden" name="template0" value="query"/>
<input type="hidden" name="fieldname0" value="CABINET_ID"/>
<input type="select" name="fieldname0" title="Search By:">
<option value="CABINET_ID">Cabinet ID</option>
<option value="SYSTEM_ID">System ID</option>
</input>
<input type="select" name="comparitor0" title="That: ">
<option value="like-icase">Contains</option>
<option value="right-like-icase">Begins With</option>
<option value="eq-str">Matches Exactly</option>
</input>
<input type="user" name="value0" title=""/>
</step>
</service>
This layer renders great from the catalog and identify is working fine. The long layer select sql works great. When I use the search service above from a menu tool, the information panel fills with the search form and I can enter search criteria. When I hit the search button I get the following error:
Warning: [MapServer Error]: msShapefileOpen(): (/ms4w/apps/metrogis/maps/mapfiles_metro/assets/SELECT OBJECTID, SHAPE, SYSTEM_ID, CABINET_ID, LAYOUT_URL, CABINET_TYPE, CABINET_VOLTS, ROADWAY_NAME, LOCATION, QUAD, METER_VENDOR, METER_ACCOUNT, METER_ADDRESS, METER_NBR, PREMISE_NBR, OWNER_CODE, SHARED_POWER_CSV, format(DATE_LOGGED,'mm/dd/yyyy') AS CDATE_LOGGED, format(DATE_INSTALLED, 'mm/dd/yyyy') AS CDATE_INSTALLED, format(DATE_TURNON, 'mm/dd/yyyy') AS CDATE_TURNON, format(DATE_RETIRED, 'mm/dd/yyyy') AS CDATE_RETIRED, GEOMSRC_CODE FROM LIGHT_CABINETS WHERE (DATE_TURNON < date() OR DATE_TURNON Is NULL) AND (DATE_RETIRED > date() OR DATE_RETIRED Is NULL)) in C:\ms4w\apps\metrogis\htdocs\php\query.php on line 318
I find it odd that "/ms4w/apps/metrogis/maps/mapfiles_metro/assets/" is prefixed to the select or data value. Shouldn't the database location and name be somewhere in there?
I have tried keeping the data value a simple table/feature class name to rule that out. Still an error.
I've tried navigating the query.php (geomoose 2.0) but I can't seem to make heads or tails of it.
------------------------------------------------------------------------------
This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
_______________________________________________
Geomoose-users mailing list
Geomoose-users at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geomoose-users
More information about the Geomoose-users
mailing list