[mapserver-users] how to find queryresult from external db in the map

Peter Bruijnen dumper@mailz.nl
Mon, 2 Sep 2002 20:03:50 +0200


This is a multi-part message in MIME format.

------=_NextPart_000_0023_01C252BB.DAF8DDE0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm using mapserver (version 3.6) to query a cadastre map. When clicking =
on a parcel i get (via an asp-script) the users from that parcel. A =
parcel can have more then one user. Because of this one to many =
relationship it's not possible to include the users directly in de shape =
dbf. Otherwise this should be the easiest way i presume. Now the =
cadastre number selected in the shape is the link to an external access =
database with that same cadastre number. Al the corresponding records =
wil be shown (via asp-script).

So far everything works (perfect) ...
But i also want to search the other way around. Select a user from the =
access database (via another asp-script?) and highlight the =
corresponding parcels in de cadastre map. How can i do this. I'm quite =
new with Mapserver so any help is welcome.=20

Thanks in advance,
Peter Bruijnen

------=_NextPart_000_0023_01C252BB.DAF8DDE0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>I'm using mapserver (version 3.6) to =
query a=20
cadastre map. When clicking on a parcel i get (via an =
asp-script)&nbsp;the users=20
from that parcel. A parcel can have more then one user. Because of this =
one to=20
many relationship it's not possible to include the users directly in de =
shape=20
dbf. Otherwise this should be the easiest way i presume. Now the =
cadastre number=20
selected in the shape is the link to an external access database with =
that same=20
cadastre number. Al the corresponding records wil be shown (via=20
asp-script).</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>So far everything works (perfect) =
.</FONT><FONT=20
face=3DArial size=3D2>..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>But i also want to search the other way =
around.=20
Select a user from the access database (via another asp-script?) and =
highlight=20
the corresponding parcels in de cadastre map. How can i do this. I'm =
quite new=20
with Mapserver so any help is welcome. </FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Peter Bruijnen</FONT><FONT =
color=3D#448593=20
face=3D'"Verdana", Geneva, MS sans-serif' =
size=3D-2></DIV></FONT></BODY></HTML>

------=_NextPart_000_0023_01C252BB.DAF8DDE0--