<DIV>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. </DIV>
<DIV> </DIV>
<DIV>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.</DIV>
<DIV> </DIV>
<DIV>Thank you</DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Joao Antunes<BR></DIV>
<DIV><BR><B><I>Didrik Pinte <pinted@TISCALI.</I></B>wrote:</DIV>
<BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid">Le mercredi 09 février 2005 à 10:57 +0000, joÿffffffffffe3o Antunes a<BR>écrit :<BR>> DATA "SELECT * FROM comuni_abruzzo_gb LEFT JOIN<BR>> 'ODBC:prova'.zzz ON comuni_abruzzo_gb.Id = zzz.ID"<BR>> <BR><BR><BR>> <BR>> Warning: [MapServer Error]: msDBFGetItemIndex(): Item 'FIELD' not<BR>> found. in c:\programmi\apache group\apache\htdocs\abruzzo<BR>> \_test_odbc.php on line 6<BR><BR>> Can someone give me a hand with this?<BR><BR>Send us the description of your shapefile and the desc of the zzz table.<BR><BR>Didrik<BR><BR><BR>> ATTACHMENT part 2 application/pgp-signature name=signature.asc<BR></BLOCKQUOTE><p>
<hr size=1> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="http://uk.rd.yahoo.com/mail/taglines/default/messenger/*http://uk.messenger.yahoo.com"><strong><font face="Arial, Helvetica, sans-serif">ALL-NEW
Yahoo! Messenger</font></strong></a><font face="Arial, Helvetica, sans-serif"><strong>
- all new features - even more fun!</strong></font><strong><font color="#FF9900">
</font></strong></font>