Hello!
I'd like some help regarding my use of JOIN in my mapserver setup. I'm
using two sets of data, a base shapefile ("reg_bndary") containing
basically place information and system-generated csv files containing
all the relevant information regarding these places in the shapefiles.
Both have a common field called Place_ID to be used for the join. I
was planning to use these csv in times when the users want to query
for detailed information on these places. My map file looks like this
(the JOIN part is near the end):
NAME reg_bndary2000.map
SIZE 600 600
EXTENT 114.03 3.8315 131.33 21.1585
SHAPEPATH "data"
IMAGETYPE PNG
UNITS meters
WEB
TEMPLATE 'reg_bndary2000.html'
# IMAGEPATH '/home/mis/DIRP/maps/'
# IMAGEURL 'home/mis/DIRP/maps/'
IMAGEPATH '/home/yronald/htdocs/maps/test_map/maps/'
IMAGEURL '/test_map/maps/'
END #WEB
QUERYMAP
SIZE 600 600
STATUS ON
STYLE SELECTED
COLOR 255 0 0
END
(...)
LAYER
NAME CY_2000
TYPE polygon
STATUS ON
DATA reg_bndary
CLASSITEM COUNT
LABELITEM REGION
CLASS
NAME "443 - 688"
EXPRESSION ([COUNT]>=443 AND [COUNT]<=688)
COLOR 205 0 0
OUTLINECOLOR 0 0 0
LABEL
COLOR 0 0 255
SIZE LARGE
END
TEMPLATE "reg_bndary2000_dbf.html"
END # CLASS
CLASS
NAME "226 - 442"
EXPRESSION ([COUNT]>=226 AND [COUNT]<=442)
COLOR 255 193 193
OUTLINECOLOR 0 0 0
LABEL
COLOR 0 0 255
SIZE LARGE
END
TEMPLATE "reg_bndary2000_dbf.html"
END # CLASS
CLASS
NAME "106 - 225"
EXPRESSION ([COUNT]>=106 AND [COUNT]<=225)
COLOR 154 255 154
OUTLINECOLOR 0 0 0
LABEL
COLOR 0 0 0
SIZE LARGE
END
TEMPLATE "reg_bndary2000_dbf.html"
END # CLASS
CLASS
NAME "0 - 105"
EXPRESSION ([COUNT]>=0 AND [COUNT]<=105)
COLOR 0 100 0
OUTLINECOLOR 0 0 0
LABEL
COLOR 0 0 0
SIZE LARGE
END
TEMPLATE "reg_bndary2000_dbf.html"
END # CLASS
CLASS
NAME "No Data"
EXPRESSION ([COUNT]="")
COLOR 255 255 255
OUTLINECOLOR 0 0 0
LABEL
COLOR 0 0 0
SIZE LARGE
END
TEMPLATE "reg_bndary2000_dbf.html"
END # CLASS
HEADER "reg_bndary2000_header.html"
FOOTER "reg_bndary2000_footer.html"
JOIN
NAME "reg_join"
CONNECTIONTYPE CSV
TABLE "lgu_DB_DACCESS_PROV.csv"
FROM "Place_ID"
TO "1"
TEMPLATE "reg_bndary 2000_dbf.html"
END #join
END # LAYER
END # MAPFILE
The template file used for , "reg_bndary 2000_dbf.html", contains
simply the following:
[reg_join_REGION]<br>
[reg_join_PLACE]
When when I test this, I get the following error:
msQueryByPoint(): Search returned no results. No matching
record(s) found.
Can somebody help me tell me what is wrong in my setup?
Thanks!
Maricris
