[Mapserver-users] PHP/MapScript Query results with joined tables (new user)
Mike Leahy
mgleahy@fes.uwaterloo.ca
Mon, 12 May 2003 16:55:05 -0500
This is a multi-part message in MIME format.
------=_NextPart_000_0005_01C318A7.3FDCB5E0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Hello,
I'm a new user trying to setup an application using MapServer with
PHP/MapScript on a Windows XP/IIS platform (with all the most recent
upgrades from the Microsoft update site). I'm using one of the 3.6.5
builds (I don't know offhand exactly which one, but it seems to be
stable).
My issue is that when I join a DBF to one of the shape files in the map,
I am unable to display any results from the joined table, whether I use
a single or multiple join (and I will surely need to use a multiple join
at some point). From a brief inspection of the code in query.phtml and
the map_query.php wrapper, it seems to me that there is no code that
handles joined tables.and that the "template" specified in the MapFile
is not even used in the generation of the query output.
I'm hoping that there might be someone who knows what I've missed, or
what approach I should take - is there some additional code I should
obtain in order to handle joined tables?
I apologize if this is a topic that has already been covered - I was
unable to locate relevant results from a search of the list archive.
Kind regards,
Mike
------=_NextPart_000_0005_01C318A7.3FDCB5E0
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<html>
<head>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<meta name=3DGenerator content=3D"Microsoft Word 10 (filtered)">
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
span.EmailStyle17
{font-family:Arial;
color:windowtext;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=3DEN-CA link=3Dblue vlink=3Dpurple>
<div class=3DSection1>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Hello,</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I’m a new user trying to setup an application =
using MapServer
with PHP/MapScript on a Windows XP/IIS platform (with all the most =
recent
upgrades from the Microsoft update site). I’m using one of =
the
3.6.5 builds (I don’t know offhand exactly which one, but it seems =
to be
stable).</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>My issue is that when I join a DBF to one of the =
shape files
in the map, I am unable to display any results from the joined table, =
whether I
use a single or multiple join (and I will surely need to use a multiple =
join at
some point). From a brief inspection of the code in query.phtml =
and the map_query.php
wrapper, it seems to me that there is no code that handles joined =
tables…and
that the “template” specified in the MapFile is not even =
used in
the generation of the query output.</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I’m hoping that there might be someone who =
knows what
I’ve missed, or what approach I should take – is there some
additional code I should obtain in order to handle joined =
tables?</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>I apologize if this is a topic that has already been =
covered
– I was unable to locate relevant results from a search of the =
list
archive.</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'> </span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Kind regards,</span></font></p>
<p class=3DMsoNormal><font size=3D2 face=3DArial><span =
style=3D'font-size:10.0pt;
font-family:Arial'>Mike</span></font></p>
</div>
</body>
</html>
------=_NextPart_000_0005_01C318A7.3FDCB5E0--
_______________________________________________
Mapserver-users mailing list
Mapserver-users@lists.gis.umn.edu
http://lists.gis.umn.edu/mailman/listinfo/mapserver-users