[Chameleon] Using and display JOIN's with Chameleon

[Jonathon Coombes]

On Wed, 2006-01-11 at 15:45 +1100, Jonathon Coombes wrote:
> On Wed, 2006-01-11 at 08:32 +0800, Delfos, Jacob wrote:
> > Jonathon,
> > 
> > I don't think those type of joins can do what you want it to do in
> > Chameleon. You would not get access to the attributes. I tried it the
> > other day, without success. However, you could try an OGR join. That
> > should work with CSV as well (or you could convert to DBF). This allows
> > for querying and labelling using the joined information. 
> > 
> > This is the layer definition I used:
> > 
> > ------------------------------------------------------------------------
> > ------------
> > LAYER
> >  NAME 'Geology'
> >  CONNECTIONTYPE OGR
> >  CONNECTION "c:/data/gp.shp"
> >  DATA "SELECT a.*,b.* FROM gp a LEFT JOIN 'c:/data/descr.dbf'.descr b ON
> > a.CODE=b.CODE"
> > 
> >  LABELITEM 'a.CODE'
> > 
> >  DUMP TRUE
> >  TEMPLATE "ttt" # this isn't used, but needs to be here for queries
> >  TOLERANCE 3
> >  TOLERANCEUNITS PIXELS
> > 
> > [...]
> > 
> > END #LAYER
> 
> Hi Jacob,
> 
> Thanks for the tip. I had looked at that a few days ago, but lost
> track of it and was trying it using the JOIN method instead.
> 
> I am trying to implement an OGR layer similar to what you have
> presented above. I set it up and it displays the symbols etc,
> but when I query, there is no data? Are these layers able to
> be queried?

Ooops.. My stuffup here, I had been playing around with the
Query widget. Seems to be working now. Thanks.

Regards
Jonathon