[Chameleon] sql query widget

[Julien-Samuel Lacroix]

Hi Joel,

Currently the SQLQuery widget can only query MySQL database, but it has 
been designed to be able to query any other DB available from PHP with 
only some modification. So anyone who can do PHP code should be able to 
copy/paste the MYSQL code to whatever they want.

If MySQL is what you need (or if you add the DB format you want), then 
check the documentation at:
http://www.maptools.org/chameleon/wiki/SQLQuery

In short, you need to specify your:
server, user, password, DB and query

It will return your result in a shared resource. Then you ca do whatever 
you want with it. For example put it in a map if it had lat/lon fields 
with the MapImageSharedResource widget.
http://www.maptools.org/chameleon/wiki/MapImageSharedResource

Or in a table with the Table widget:
http://www.maptools.org/chameleon/wiki/Table

Thanks
Julien

Joel Rivard wrote:
> Hey List,
> 
> Does anybody know how the sql query widget works?  I'd like to know 
> whether or not I could use this widget to query local data for a map.
> 
> Cheers,
> 
> Joel
> _______________________________________________
> Chameleon mailing list
> Chameleon at lists.maptools.org
> http://lists.maptools.org/mailman/listinfo/chameleon
> 

-- 
------------------------------------------------------------
Julien-Samuel Lacroix            jlacroix at dmsolutions.ca
DM Solutions Group               http://www.dmsolutions.ca/
------------------------------------------------------------