[Chameleon] Using and display JOIN's with Chameleon

[Jonathon Coombes]

On Tue, 2006-01-10 at 17:45 -0500, Paul Spencer wrote:
> I would probably take the brute force method and query the dbf  
> manually by looping through the records in the csv file.

Hi Paul,

I am wondering about a couple of points though:

1. It is not a dbf, it is csv file.
2. This is something that I may do more and more over time, so
   having a reproducable, generic method of getting csv data 
   into Chameleon would be useful.

I actually started developing a CSVQuery widget before I found
the JOIN option, but if JOIN is not implemented, then I may have
to start implementing the widget again.

Is this form of widget going to match point 2 for my needs, or
is there a better way?

Regards
Jonathon

> On 10-Jan-06, at 5:32 PM, Jonathon Coombes wrote:
> 
> > On Tue, 2006-01-10 at 16:22 -0500, Paul Spencer wrote:
> >> 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???
> >
> > Hi Paul,
> >
> > Thanks for the quick reply. Assuming that JOIN is not supported by the
> > PHP mapscript api, what would be the next best way of doing this using
> > the Chameleon widgets?
> >
> > Regards
> > Jonathon
> >
> >> 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/|
> >> +-----------------------------------------------------------------+
> >
> >
> 
> +-----------------------------------------------------------------+
> |Paul Spencer                           pspencer at dmsolutions.ca   |
> +-----------------------------------------------------------------+
> |Applications & Software Development                              |
> |DM Solutions Group Inc                 http://www.dmsolutions.ca/|
> +-----------------------------------------------------------------+