<br><font size=2 face="sans-serif">Have a look at this ticket</font>
<br><font size=2 face="sans-serif">http://trac.osgeo.org/mapserver/ticket/3999</font>
<br>
<br><font size=2 face="sans-serif">Perhaps it is a similar issue. Maybe
try to change your variable name idblock<br>
</font>
<br>
<br>
<br>
<table width=100%>
<tr valign=top>
<td width=40%><font size=1 face="sans-serif"><b>"Nicolas BOUTET"
<nicolas.boutet@geosys.com>@lists.osgeo.org</b> </font>
<br><font size=1 face="sans-serif">Envoyé par : mapserver-users-bounces@lists.osgeo.org</font>
<p><font size=1 face="sans-serif">2011-09-16 03:37</font>
<td width=59%>
<table width=100%>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">A</font></div>
<td><font size=1 face="sans-serif">"'Steve Lime'" <sdlime@gmail.com></font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">cc</font></div>
<td><font size=1 face="sans-serif">mapserver-users@lists.osgeo.org</font>
<tr valign=top>
<td>
<div align=right><font size=1 face="sans-serif">Objet</font></div>
<td><font size=1 face="sans-serif">RE: [mapserver-users] Runtime Substitution
bug</font></table>
<br>
<table>
<tr valign=top>
<td>
<td></table>
<br></table>
<br>
<br>
<br>
<br>
<br><font size=3 color=#1f497d face="Calibri">Hi Steve,</font>
<br><font size=3 color=#1f497d face="Calibri">If I remove the substitution
variable and replace it by a value, it doesn’t matter if there is a space
or not.</font>
<br><font size=3 color=#1f497d face="Calibri">I also tried with some others
SQL statements where the substitution variable is not at the end of the
SQL String. There is no problem with those SQL Statements.</font>
<br><font size=3 color=#1f497d face="Calibri"> </font>
<br><font size=3 color=#1f497d face="Calibri">Nicolas</font>
<br><font size=3 color=#1f497d face="Calibri"> </font>
<br><font size=3 face="Tahoma"><b>De :</b> Steve Lime [mailto:sdlime@gmail.com]
<b><br>
Envoyé :</b> jeudi 15 septembre 2011 20:47<b><br>
À :</b> Nicolas BOUTET<b><br>
Cc :</b> <mapserver-users@lists.osgeo.org>; <mapserver-dev@lists.osgeo.org><b><br>
Objet :</b> Re: [mapserver-users] Runtime Substitution bug</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">If you take var. substitution out
of it by hard coding an idblock value does the space still matter?</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">Steve<br>
<br>
Sent from my iPad</font>
<br><font size=3 face="Times New Roman"><br>
On Sep 15, 2011, at 11:07 AM, "Nicolas BOUTET" <</font><a href=mailto:nicolas.boutet@geosys.com><font size=3 color=blue face="Times New Roman"><u>nicolas.boutet@geosys.com</u></font></a><font size=3 face="Times New Roman">>
wrote:</font>
<br><font size=3 face="Times New Roman">Hello,</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">I’m using MapServer 6.0.1 in conjunction
with GDAL 1.8 (Tamas binaries) with IIS 7.5, and I get an issue while using
runtime substitution.</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">I have a LAYER where the data source
if defined like this :</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">
CONNECTIONTYPE
OGR</font>
<br><font size=3 face="Times New Roman">
CONNECTION
"OCI:…/….@gti5500"</font>
<br><font size=3 face="Times New Roman">
DATA
"SELECT idblock, entitiesMbr</font>
<br><font size=3 face="Times New Roman">
FROM block</font>
<br><font size=3 face="Times New Roman">
WHERE idblock =
%idBlock% "</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">Please note that there is a space
character at the end of the SQL statement, after the variable to substitute.</font>
<br><font size=3 face="Times New Roman">All is working fine while the space
is still here.</font>
<br><font size=3 face="Times New Roman">If I remove it, I get an Error
500 from the Server and the Windows Application logs register an error
in the MSVCR100.dll module.</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">Of course, the layer contains also
a validation block like this:</font>
<br><font size=3 face="Times New Roman">
VALIDATION</font>
<br><font size=3 face="Times New Roman">
idblock
'^[0-9]{1,6}$'</font>
<br><font size=3 face="Times New Roman">
END</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">It seems that this is a bug in
variable substitution. Can you confirm this? Have you already observe this
kind of issue?</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">Regards</font>
<br><font size=3 face="Times New Roman"> </font>
<br><font size=3 face="Times New Roman">Nicolas</font>
<br><font size=3 face="Times New Roman">_______________________________________________<br>
mapserver-users mailing list</font><font size=3 color=blue face="Times New Roman"><u><br>
</u></font><a href="mailto:mapserver-users@lists.osgeo.org"><font size=3 color=blue face="Times New Roman"><u>mapserver-users@lists.osgeo.org</u></font></a><font size=3 color=blue face="Times New Roman"><u><br>
</u></font><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users"><font size=3 color=blue face="Times New Roman"><u>http://lists.osgeo.org/mailman/listinfo/mapserver-users</u></font></a><tt><font size=2>_______________________________________________<br>
mapserver-users mailing list<br>
mapserver-users@lists.osgeo.org<br>
http://lists.osgeo.org/mailman/listinfo/mapserver-users<br>
</font></tt>
<br>
<br>
<br>