Using JOIN for querying

[Manfred Meier]

Hi,

I do not know how to use JOIN. But since nobody replied to your 
question, perhaps you can add information, if the test you made, give 
you the correct result when you do !!not!! use the JOIN.

If I understand right, then JOIN adds some data but no spatial 
information. So at the first sight it seems unlikely that the result of 
msQueryByPoint is related to a JOIN.

So does this message appear only when you add the JOIN to the mapfile?

Manfred



cris ricana schrieb:
> 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
>   (...)
>  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
>