Also I have the same problem.....
Have you succeeded in resolving it?
I want to connect the chart you possess of mysql with the dbf of the
shpfile. The key field and NOME in the dbf and DIGA in mysql.
#My MAPFILE
LAYER
NAME "Dighe"
TYPE point
DATA "Dighe"
METADATA
"DESCRIPTION" "Dighe"
"RESULT_FIELDS" "NOME,COD_INV,TIPO_INV,SCHEDA"
"RESULT_HEADERS" "Nome Diga, Codice, Tipologia,Scheda"
"RESULT JOIN"
"mysql://user:password at localhost/db_invasi||invasi at [EMAIL PROTECTED] at
cod_inv,tipo_inv,scheda||nome||1"
END # Metadata
CLASS
Name 'Dighe'
COLOR 255 255 0
SYMBOL 'star'
SIZE 8
TEMPLATE void
END # Class
JOIN
CONNECTIONTYPE mysql
CONNECTION "localhost:root:miapass:db_invasi"
TABLE "invasi"
TO "DIGA"
NAME ""
FROM "NOME"
END #Join
END # Layer
--
View this message in context:
http://www.nabble.com/JOIN-datasource-tf1960596.html#a5503672
Sent from the Pmapper-users forum at Nabble.com.
