<html><body bgcolor="#FFFFFF"><div>If you take var. substitution out of it by hard coding an idblock value does the space still matter?</div><div><br></div><div>Steve<br><br>Sent from my iPad</div><div><br>On Sep 15, 2011, at 11:07 AM, "Nicolas BOUTET" <<a href="mailto:nicolas.boutet@geosys.com">nicolas.boutet@geosys.com</a>> wrote:<br><br></div><div></div><blockquote type="cite"><div><div class="WordSection1"><p class="MsoNormal">Hello,<o:p></o:p></p><p class="MsoNormal"><o:p> </o:p></p><p class="MsoNormal"><span lang="EN-US">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.<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-US">I have a LAYER where the data source if defined like this :<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-US"> CONNECTIONTYPE OGR<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"> CONNECTION "OCI:…/….@gti5500"<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"> DATA "SELECT idblock, entitiesMbr<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"> FROM block<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"> WHERE idblock = %idBlock% "<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-US">Please note that there is a space character at the end of the SQL statement, after the variable to substitute.<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US">All is working fine while the space is still here.<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US">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.<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-US">Of course, the layer contains also a validation block like this:<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"> VALIDATION<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"> idblock '^[0-9]{1,6}$'<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"> END<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-US">It seems that this is a bug in variable substitution. Can you confirm this? Have you already observe this kind of issue?<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-US">Regards<o:p></o:p></span></p><p class="MsoNormal"><span lang="EN-US"><o:p> </o:p></span></p><p class="MsoNormal"><span lang="EN-US">Nicolas<o:p></o:p></span></p></div></div></blockquote><blockquote type="cite"><div><span>_______________________________________________</span><br><span>mapserver-users mailing list</span><br><span><a href="mailto:mapserver-users@lists.osgeo.org">mapserver-users@lists.osgeo.org</a></span><br><span><a href="http://lists.osgeo.org/mailman/listinfo/mapserver-users">http://lists.osgeo.org/mailman/listinfo/mapserver-users</a></span><br></div></blockquote></body></html>