[Mapserver-users] Dynamically change FILTER object using OGR connection to Oracle Spatial

Thu Jul 1 22:06:06 PDT 2004

This is a multi-part message in MIME format.

------_=_NextPart_001_01C45FF2.47CA4D42
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

We currently can dynamically change the FILTER object in the map file =
when
using a shapefile, however when we use the same code to change the =
FILTER
object when connected to an Oracle database it doesn't do anything. The
FILTER object is being used to draw the map if you hard code the =
FILTERITEM
and FILTER objects in the map file (and displays correctly) but nothing
happens at all when it is changed dynamically.

=20

Eg in the map file the following displays the two geometries for the =
enos
given. The connection type is OGR to an Oracle database with the DATA =
object
being an SQL statement to select the geometry field and a unique number =
(ie
eno) identifying the row. LAYER "surveys" FILTERITEM "eno" FILTER
/51378|51397/

=20

But when we use the dynamic call
"mapserv?map=3Dmars.map&layer=3Dsurveys&template=3Dframe_map.html&map_sur=
veys_filte
r=3D/51397/", it continues to draw both the geometries given in the map =
file
and not draw only the geometry given in the call above.

=20

Does anyone know if changing the FILTER object dynamically only works =
when
the data is coming from a shapefile?=20

Or does it work direct from the database but we have it wrong somehow?

=20

=20

=20

------_=_NextPart_001_01C45FF2.47CA4D42
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:595.3pt 841.9pt;
	margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=3DEN-AU link=3Dblue vlink=3Dpurple>

<div class=3DSection1>

We currently can =
dynamically
change the FILTER object in the map file when using a shapefile, however =
when
we use the same code to change the FILTER object when connected to an =
Oracle
database it doesn't do anything. The FILTER object is being used to draw =
the
map if you hard code the FILTERITEM and FILTER objects in the map file =
(and
displays correctly) but nothing happens at all when it is changed =
dynamically.

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'> </span></font></p>

Eg in the map file =
the
following displays the two geometries for the enos given. The connection =
type
is OGR to an Oracle database with the DATA object being an SQL statement =
to
select the geometry field and a unique number (ie eno) identifying the =
row.
LAYER "surveys" FILTERITEM "eno" FILTER =
/51378|51397/

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'> </span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>But when we use the =
dynamic
call =
"mapserv?map=3Dmars.map&layer=3Dsurveys&template=3Dframe_map=
.html&map_surveys_filter=3D/51397/",
it continues to draw both the geometries given in the map file and not =
draw
only the geometry given in the call above.</span></font></p>

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier =
New"'> </span></font></p>

Does anyone know if =
changing
the FILTER object dynamically only works when the data is coming from a =
shapefile?

<p class=3DMsoNormal style=3D'text-autospace:none'><font size=3D2 =
face=3D"Courier New"><span
style=3D'font-size:10.0pt;font-family:"Courier New"'>Or does it work =
direct from
the database but we have it wrong somehow?</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'> </span></font></p>

<p class=3DMsoNormal style=3D'margin-left:36.0pt'><font size=3D3
face=3D"Times New Roman"><span =
style=3D'font-size:12.0pt'> </span></font></p>

</div>

</body>

</html>
=00
------_=_NextPart_001_01C45FF2.47CA4D42--