[Chameleon] Using and display JOIN's with Chameleon

[Paul Spencer]

Jonathon,

Chameleon uses mapserver's php api for the low level stuff like  
queries.  I'm not sure if the script api supports this join construct  
or not.  Any mapserver-ites???

Paul

On 10-Jan-06, at 4:14 PM, Jonathon Coombes wrote:

> Hi All,
>
> I am trying to combine shapefile attributes with a CSV file, but
> cannot see what is the best way to do it. I have my layer definition
> as follows:
>
> LAYER
>   NAME "LayerName"
>   TYPE POINT
>   DATA layerdata
>   STATUS ON
>   TEMPLATE "ttt_query.html"
>
>   JOIN
>     CONNECTIONTYPE CSV
>     TABLE "datafile.csv"
>     TO "ID"
>     NAME "csvlayerjoin"
>     FROM "InfoID"
>     TEMPLATE "ttt_join.html"
>   END
> END
>
> My question is - does Chameleon support JOIN's and what is the best
> method to display the results? They do not seem to come up in the
> Query results, so I presume it is with MapTips or LayerAttributes?
> Has anyone done this before?
>
> Regards
> Jonathon
>
> _______________________________________________
> Chameleon mailing list
> Chameleon at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/chameleon
>

+-----------------------------------------------------------------+
|Paul Spencer                           pspencer at dmsolutions.ca   |
+-----------------------------------------------------------------+
|Applications & Software Development                              |
|DM Solutions Group Inc                 http://www.dmsolutions.ca/|
+-----------------------------------------------------------------+