MySQL access and joins

[Kralidis,Tom [Burlington]]

> -----Original Message-----
> From: Attila Csipa [mailto:plists at prometheus.org.yu] 
> Sent: Thursday, 08 September, 2005 18:34
> To: Kralidis,Tom [Burlington]
> Cc: MAPSERVER-USERS at lists.umn.edu
> Subject: Re: [UMN_MAPSERVER-USERS] MySQL access and joins
> 
> 
> On Thursday 08 September 2005 21:02, Kralidis,Tom [Burlington] wrote:
> > > > Will simple MySQL tables work as the join table?  I believe 
> > > > --with-mygis will work on a non-sppatial DB
> > >
> > > Yes, but this will work ONLY for template based queries (this
> >
> > Thanks for the info.  What do you mean by template based 
> queries?  My 
> > overall goal is to generate a map (with shp2img) whose 
> mapfile defines 
> > a layer which has a join btw a shapefile and MySQL table, and CLASS 
> > items based on expressions in columns in the MySQL table.
> 
> A query defines the 'what', not the 'how'. So basically you 
> CAN do 'find me 
> the shapefile points that have a mysql field value of X', but 
> NOT DIRECTLY 
> 'paint shapefile points with mysql field value X green' - 
> which seems is what 
> you want to do with it.
> 

So this is to say that mapserv CGI can't handle this, but using
something like mapscript can?  Is this what you mean by template
queries?

Thanks

..Tom