[Chameleon] Using and display JOIN's with Chameleon

[Jonathon Coombes]

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?

Regards
Jonathon