<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-15"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hi Stephan,<br>
<br>
On 22/02/2011 3:44 AM, Stephan Holl wrote:
<blockquote cite="mid:20110222094428.5b7c7e3c@thoe.hq.intevation.de"
type="cite">
<pre wrap="">Hello list,
while playing with MapServer WFS Filter Encoding capabilities I found
some strange things when it comes to form the DB-queries (the
requested layer is PostGIS-driven).
It seems that there will always be a full table-scan and later on the FE
will be applied. Is this done by design?
</pre>
</blockquote>
Filters that do include spatial filters end up using the mapserver
experssions. 'Simple' filters should end be using traslated into the
layer's filter expression and end up being used by postgis as part
of the data selection. What does the filter encoding looks like?<br>
<br>
<blockquote cite="mid:20110222094428.5b7c7e3c@thoe.hq.intevation.de"
type="cite">
<pre wrap="">Using URL-substitutions of the Search-keyword and apply it to a
FILTER-element the resulting SQL-query has the given WHERE-filter set.
But this opens the door for SQL-injections AFAIK. Setting the
validation pattern is a little prevention.
Are there any other ways to realize a keyword-driven search with
MapServer beside FE IsLike or FILTER-substitution?
I am using MS 5.6.5 on debian stable.
TIA
Stephan
</pre>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
_______________________________________________
mapserver-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a>
<a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
----------------------------------------------------------------
Assefa Yewondwossen
Software Analyst
Email: <a class="moz-txt-link-abbreviated" href="mailto:yassefa@dmsolutions.ca">yassefa@dmsolutions.ca</a>
<a class="moz-txt-link-freetext" href="http://www.dmsolutions.ca/">http://www.dmsolutions.ca/</a>
Phone: (613) 565-5056 (ext 14)
Fax: (613) 565-0925
----------------------------------------------------------------
</pre>
</body>
</html>