[mapserver-users] Problem querying personal GDB

[Bistrais, Bob]

I see this is in the section for using a PostGIS layer.  Is that applicable for an ESRI Personal GDB?

From: Brent Fraser [mailto:bfraser at geoanalytic.com]
Sent: Tuesday, July 03, 2012 6:01 PM
To: Bistrais, Bob
Cc: mapserver-users at lists.osgeo.org
Subject: Re: [mapserver-users] Problem querying personal GDB

Bob,

  You may need to add a "using unique" clause  like "using unique gid" http://www.mapserver.org/input/vector/postgis.html#data-access-connection-method



Best Regards,

Brent Fraser
On 7/3/2012 2:12 PM, Bistrais, Bob wrote:
Please excuse me if this is redundant- I've also posted this to the GeoMoose list, and I can't remember what I've posted where on this issue.

I am building an application with MapServer 6.0.2, and GeoMoose 2.6 on the front end.  One of the layers is contained in an ESRI personal Geodatabase, i.e. a Microsoft Access database.

This layer displays properly.  I can also do an Identify on it and get expected results.  It's when I try to do a Search (a select by attributes) when things fall apart.  Checking the error log, I see     msEvalExpression(): General error message. Cannot evaluate expression, no item index defined.

It's also worth noting that, if I convert the layer to shapefile and use that in the application, it will work.  But there's a few operational considerations that make it preferable to use the GDB.  So the problem seems to be with querying the MDB.  Does anyone have any ideas?




_______________________________________________

mapserver-users mailing list

mapserver-users at lists.osgeo.org<mailto:mapserver-users at lists.osgeo.org>

http://lists.osgeo.org/mailman/listinfo/mapserver-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20120705/51c144f7/attachment.htm>