[mapserver-users] Problem querying personal GDB

[Brent Fraser]

Bob,
   It's just a guess on my part.  There was a similar post on the 
Geomoose list last year:
http://osgeo-org.1560.n6.nabble.com/Geomoose-users-query-php-and-pgdb-tt4929185.html#a4929188


Best Regards,
Brent Fraser

On 7/5/2012 8:08 AM, Bistrais, Bob wrote:
>
> 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/09a190a5/attachment.html>