[Mapserver-users] Another JOIN problem

Thu Jul 15 04:14:05 EDT 2004

--0-571256974-1089879245=:14774
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi List!
I'm using MapServer version 4.0 and I have a problem with JOIN. Hier is my .map file:

 LAYER
  TYPE POLYGON
  STATUS OFF
  DATA elimpdis
  NAME elimpdis
  CLASS
   COLOR -1 -1 -1
   OUTLINECOLOR 58 38 0
   SYMBOL 'circle' 
   SIZE 3
  END # end class
# QUERYITEM "DISTRITO"
# QUERY
  FILTERITEM "DISTRITO"
  JOIN
   FROM DISTRITO
   TO DIS
   NAME prova
   TABLE "taules/ELE95.dbf"
   TYPE multiple
   TEMPLATE querys/qprova.html
  END #end join
 END # end layer

Here is my TEMPLATE file (qprova.html):
<html>
<head><title>Resultats Districtes</title></head>
<body>
[prova] 
Districte:[DISTRITO]
IC:[IC]
PP:[PP]
</body>
</html>

If I do like this the result is: msQueryByPoint(): Search returned no results. No matching record(s) found. 

I don't know what exactly do the FILTERITEM, but is the only way I could do the join, because when I tried with QUERYITEM I obtain: loadLayer(): Unknown identifier. Parsing error near (QUERYITEM):(line 152) 
How can I solve my problem?

I had seen in the mailing list archive there are lot of problems with JOIN, it is possible to do with Mapserver 4.0? What I'm doing wrong?

Thanks in advanced, and excuse me for my bad-worse english.
Helena.

---------------------------------

 [input]   [input]   [input] 
--0-571256974-1089879245=:14774
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

<DIV>Hi List!<BR>I'm using MapServer version 4.0 and I have a problem with JOIN. Hier is my .map file:</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;LAYER<BR>&nbsp; TYPE POLYGON<BR>&nbsp; STATUS OFF<BR>&nbsp; DATA elimpdis<BR>&nbsp; NAME elimpdis<BR>&nbsp; CLASS<BR>&nbsp;&nbsp; COLOR -1 -1 -1<BR>&nbsp;&nbsp; OUTLINECOLOR 58 38 0<BR>&nbsp;&nbsp; SYMBOL 'circle' <BR>&nbsp;&nbsp; SIZE 3<BR>&nbsp; END # end class<BR># QUERYITEM "DISTRITO"<BR># QUERY<BR>&nbsp; FILTERITEM "DISTRITO"<BR>&nbsp; JOIN<BR>&nbsp;&nbsp; FROM&nbsp;DISTRITO<BR>&nbsp;&nbsp; TO DIS<BR>&nbsp;&nbsp; NAME prova<BR>&nbsp;&nbsp; TABLE "taules/ELE95.dbf"<BR>&nbsp;&nbsp; TYPE multiple<BR>&nbsp;&nbsp; TEMPLATE querys/qprova.html<BR>&nbsp; END #end join<BR>&nbsp;END # end layer</DIV>
<DIV>&nbsp;</DIV>
<DIV>Here is my TEMPLATE file (qprova.html):</DIV>
<DIV>&lt;html&gt;<BR>&lt;head&gt;&lt;title&gt;Resultats Districtes&lt;/title&gt;&lt;/head&gt;<BR>&lt;body&gt;<BR>[prova] <BR>Districte:[DISTRITO]<BR>IC:[IC]<BR>PP:[PP]<BR>&lt;/body&gt;<BR>&lt;/html&gt;</DIV>
<DIV>&nbsp;</DIV>
<DIV>If I do like this the result is: msQueryByPoint(): Search returned no results. No matching record(s) found. </DIV>
<DIV>&nbsp;</DIV>
<DIV>I don't know what exactly do the FILTERITEM, but is the only way I could do the join, because when I tried with QUERYITEM I obtain: loadLayer(): Unknown identifier. Parsing error near (QUERYITEM):(line 152) </DIV>
<DIV>How can I solve my problem?</DIV>
<DIV>&nbsp;</DIV>
<DIV>I had seen in the mailing list archive there are lot of problems with JOIN, it is possible to do with Mapserver 4.0? What I'm doing wrong?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks in advanced, and excuse me for my bad-worse english.</DIV>
<DIV>Helena.</DIV><p>
		<hr size=1><br>
<table><tr><td><a href="http://es.rd.yahoo.com/mail_es/tagline/search/image/*http://es.search.yahoo.com/search/es/home/"><img src="http://eur.i1.yimg.com/eur.yimg.com/i/es/mail/srchf.gif" height=80 width=230 alt="Nuevo Yahoo! Búsquedas" border=0 align="left"></a></td></tr>
<tr><td>
<!-- Yahoo! Search -->
<form method=get action="http://es.rd.yahoo.com/mail_es/tagline/search/box/*http://es.search.yahoo.com/search/es">
<input type="text" name="p" size=25> <input type="hidden" name="fr" value="mailtag"> <input type="submit" value="Buscar">
</form>
<!-- End Yahoo! Search -->
</td></tr></table>
--0-571256974-1089879245=:14774--