Thematic map using MySQL
joÿffffffffffe3o Antunes
bluetuna_goes_skying at YAHOO.CO.UK
Wed Feb 9 05:29:18 PST 2005
The shapefile comuni_abruzzo_gb has got a unique id (field called Id) and the table zzz has got the same unique ID used to make the join between the two and an extra FIELD used to fill the polygons of the shapefile depending on its value.
Later on I would also be interested in querying the polygons with a simple querybypoint method and again access the values of the same FIELD.
Thank you
Joao Antunes
Didrik Pinte <pinted at TISCALI.wrote:
Le mercredi 09 février 2005 à 10:57 +0000, joÿffffffffffe3o Antunes a
écrit :
> DATA "SELECT * FROM comuni_abruzzo_gb LEFT JOIN
> 'ODBC:prova'.zzz ON comuni_abruzzo_gb.Id = zzz.ID"
>
>
> Warning: [MapServer Error]: msDBFGetItemIndex(): Item 'FIELD' not
> found. in c:\programmi\apache group\apache\htdocs\abruzzo
> \_test_odbc.php on line 6
> Can someone give me a hand with this?
Send us the description of your shapefile and the desc of the zzz table.
Didrik
> ATTACHMENT part 2 application/pgp-signature name=signature.asc
---------------------------------
ALL-NEW Yahoo! Messenger - all new features - even more fun!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20050209/8b68992a/attachment.htm>
More information about the MapServer-users
mailing list