[Geomoose-users] query.php and pgdb

[Brent Fraser]

Michael,

   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?

Best Regards,
Brent Fraser


On 11/15/2011 6:32 AM, Reynolds, Michael J. (DOT) wrote:
>
> 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).
>
> I think I have it narrowed down to an issue with the setFilter or the 
> $filter_string.
>
> 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).
>
> My map file is very simple for testing purposes:
>
> CONNECTIONTYPE OGR
>
>             CONNECTION 'mte_systems.mdb'
>
>        DATA "SIGNAL_SYSTEMS"
>
> No class items or expressions.
>
> The filter query.php builds is $filter_string = upper(SYSTEM_ID) like 
> '%'||upper('27')||'%'
>
> The field SYSTEM_ID is all capital in the database (matters?).  The 
> SYSTEM_ID field is a number data type.
>
> MS debug is active and reports the following when the setFilter line 
> is active:
>
> [Tue Nov 15 07:25:17 2011].25000 getSymbol(): Symbol definition error. 
> Parsing error near (upper):(line 228)
>
> [Tue Nov 15 07:25:17 2011].695000 msEvalExpression(): General error 
> message. Cannot evaluate expression, no item index defined.
>
> ... repeat above line equal number of times to the number of all 
> features in the feature class ...
>
> [Tue Nov 15 07:25:17 2011].788000 msQueryByRect(): Search returned no 
> results. No matching record(s) found.
>
> [Tue Nov 15 07:25:18 2011].116000 msFreeMap(): freeing map at 036B6A18.
>
> Not sure what Item Index might be referring too.  The PGDB has an 
> OBJECTID field.
>
> Any suggestions on what to fiddle with next?
>
>
>
> _______________________________________________
> Geomoose-users mailing list
> Geomoose-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/geomoose-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/geomoose-users/attachments/20111115/55860982/attachment.html