<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style>
</head>
<body class='hmmessage'>
Hi,<br><br>I am trying to use mapserver to generate image maps from a PostGIS connection based upon a user entered FILTER. The data column I am trying to filter by is a tsvector column type. So the FILTER for my LAYER looks something like this:<br><br>FILTER "textsearchable_index_col @@ to_tsquery('search terms')"<br><br>I do have things working where I can hard code the FILTER for the LAYER in the MAP file. Things work great and I am very happy about this. The problem lies that I would now like to allow my client application to change this FILTER dynamically through a URL request based upon what search terms the user enters. So the URL would look something like this:<br><br>http://.../mapserv?map.layer[layername].filter=%22textsearchable_index_col%20@@%20to_tsquery%28%27newsearchterms%27%29%22&mode=map&map=mapfile.map&layers=layername&map_imagetype=png&mapext=-73203436.227488+-51717904.824712+73203436.227488+51717904.824712&imgext=-73203436.227488+-51717904.824712+73203436.227488+51717904.824712&map_size=1870+1321&imgx=935&imgy=660.5&imgxy=1870+1321<br><br>I am getting the following error:<br><br>loadLayer(): Unknown identifier. Parsing error near (textsearchable_index_col @@ to_tsquery('newsearchterms')):(line 1)
<br><br>Through looking around a little, I believe the "@@" special characters in the filter parameter are causing the issue. Can anyone confirm that this is may be the case (or think of what else may be the issue) and suggest a workaround (escaping these characters in some way, etc.)?<br><br>Thanks,<br>Scott<br><br><br><div>
<div>********************************************* </div>Scott Pezanowski
<div></div>
<div></div>
<div></div>email: scottpez@hotmail.com
<div></div>*********************************************</div><br><br> </body>
</html>