DBF to Shape OGR JOIN, PHP crashes

[Christopher R. Thorne]

Hello list,
I am trying to solve an OGR Connection to JOIN a shape file to a DBF 
problem. I cannot figure out weather it is my layer definition or 
something else.

I HAVE been able to get a join work with a different data set, but it 
seems there are some problems with the layer(data) I wish to display. 
Every time I try the Join. My CPU goes to %100 do to PHP.exe failing to 
close. I have to reboot my windows machine.

Other than size of data set (meaning bigger) I cannot see any difference 
with my layer definition.

The following layer works:
   LAYER
     STATUS ON
     TYPE POLYGON
     CONNECTIONTYPE OGR
     CONNECTION "D:/maps/data/archived/nyc/nyc/taxlots2/MN_BBL.shp"
     CLASS
       STYLE
         COLOR -1 -1 -1
         OUTLINECOLOR 0 255 0
       END
     END
   END

These Joins do not:

CONNECTIONTYPE OGR
DATA "SELECT test2.FARGAP FROM MN_BBL LEFT JOIN 
'D:/maps/data/archived/nyc/nyc/dbf_joins/test2.dbf'.test2 ON 
MN_BBL.BBL=test2.BBL"
CONNECTION "D:/maps/data/archived/nyc/nyc/taxlots2/MN_BBL.shp"
CLASSITEM "test2.FARGAP"

CONNECTIONTYPE OGR
DATA "SELECT test2.FARGAP FROM MN_BBL LEFT JOIN 
'D:/maps/data/archived/nyc/nyc/dbf_joins/test2.dbf'.test2 ON 
MN_BBL.BBL=test2.BBL"
CONNECTION "D:/maps/data/archived/nyc/nyc/taxlots2"
CLASSITEM "test2.FARGAP"

Are there limitation to the OGR join that I am not aware off?

Chris

-- 
Christopher R. Thorne, GIS Specialist
-
christhorne at sympatico.ca
Tel:(613)523-6593, Ottawa ON Canada
-----------------------------