I am using OGR in my map file and have a CONNECTION and DATA lines. I have a SQL statement in the DATA. It works when I use it on the ACCESS database that is the Personal GeoDatabase in ESRI but when I put it into the map file I get an error message. It should bring back 33 records and the message says that the search brought back no results. I'm using a left join, which is in the example for OGR and geodatabases but the only join I can make work is an inner join and that doesn't bring back the correct results like the left join does.
This is the sql that atleast brings back some results, all be it not the results I am expecting: SELECT * FROM CEMSHEET_2 INNER JOIN milbank_cemetary_UTM ON CEMSHEET_2.LOT=milbank_cemetary_UTM.lot And this one brings back the expected results in access but gives me the no results returned in GeoMoose when I run a search. SELECT CEMSHEET_2.NAME, CEMSHEET_2.LOT, CEMSHEET_2.AGE FROM CEMSHEET_2 LEFT JOIN milbank_cemetary_UTM ON CEMSHEET_2.LOT = milbank_cemetary_UTM.lot >From what I have read in the documentation on mapserver, that the left join is >the only join that is suppost to work but I get results when I use inner join. Hope this makes sense. thansk Jim Hagedorn GIS Specialist [cid:[email protected]] Banner Associates, Inc. 409 22nd Avenue South * PO Box 298 * Brookings, South Dakota 57006 (605) 692-6342 * Fax (605) 692-5714 www.bannerassociates.com<http://www.bannerassociates.com/>
<<inline: image001.gif>>
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
