JOIN - hope to receive an answer... maybe from a developer {Scanned} {Scanned}

[Siki Zoltan]

Dear Paul,

I have given an example for multiple join, see in the archive.
Item number 2796.
http://lists.umn.edu/cgi-bin/wa?A2=ind0412&L=mapserver-users&P=R15784&I=-3&X=68D2EA4ED8F073B0B9&Y=siki%40agt.bme.hu

Bye
Zoltan

On Fri, 17 Jun 2005, william paul wrote:

> Hi,
> 
> I am not very advanced with MAPSEVER, but still...
> Does anyone have EVER successfully used JOIN OBJECT? I want to join a DBF with a SHP (MULTIPLE JOIN)
> 
> In Mapserver reference file (http://mapserver.gis.umn.edu/doc44/mapfile-reference.html#join) it is written "Joins are defined within a query object." WHAT IT MEANS? the map file should look like:
> LAYER
> ....
> QUERY
>     JOIN
>         etc
> I tried like this but I receive the error :loadLayer(): Unknown identifier. Parsing error near (QUERY)
> obvious the map file should look different
> 
> I have the shape (COUNTY.SHP) file with the following fields (ITEMS): SHAPE, CODE
> I have the DBF (CODE.DBF) file with the following fields (ITEMS): CODE, COUNTY, TOWN, YEAR
> I wanted to join them (MULTIPLE JOIN=ONE TO MANY), so I used as Mapserver reference say:
> 
> LAYER
> ......
> HEADER 'templates/code_header.html'
> FOOTER 'templates/code_footer.html'
> TOLERANCE 3
> 
> CLASS
>      COLOR 200 0 200
>      SIZE 10
>      SYMBOL "circule"
>      TEMPLATE 'templates/code.html'
> END
> 
> JOIN
>  FROM CODE
>  NAME CODE_JOIN
>  TABLE "E:\mapserver\shp\CODE.DBF"
>  TEMPLATE "templates\CODE.HTML"
>  TO CODE
>  TYPE multiple
> END
> 
> I receive the following result:
>  CODECOUNTYTOWNYEAR11026[COUNTY][TOWN][YEAR]
> 
> If I comment the TEMPLATE from JOIN nothink happend, but if I comment the TEMPLATE from CLASS I get the error: msQueryByRect(): Search returned no results. No matching record(s) found.
> 
> WHAT is happening? What and where I do wrong?
> DOES ANY ONE HAVE A WORKING EXAMPLE? I MEAN SOME ONE WHO USED OR USE JOIN OBJECT
> 
> There are any other ways to JOIN (ONE TO MANY) data?
> 
> Thank you in advance
> 
> William
> 
> 
> 
> 
> 		
> ---------------------------------
> Yahoo! Mail
>  Stay connected, organized, and protected. Take the tour