[Chameleon] sql query widget

[Joel Rivard]

Sorry about the duplicate

Hello,

Thank you for your response.

So this means that the SQL query widget only works with DataBases?

The problem is that the data that I have is not in a database since I 
am simply working with just a few road files in shapefile format.  This 
means that I have to query the Dbase table, which I can't seem to 
figure out how to do with chameleon.

Are there any widgets that can query a dbase table?
I want the user (students in my case)to be able to find the location of 
all the roads.  (ie. the Location of Rosemount Ave).

Can this be done with chameleon?

Cheers

Joel 


Julien-Samuel Lacroix wrote:


>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/
>------------------------------------------------------------
>