Hi Steve, If I remove the substitution variable and replace it by a value, it doesn’t matter if there is a space or not.
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. Nicolas De : Steve Lime [mailto:[email protected]] Envoyé : jeudi 15 septembre 2011 20:47 À : Nicolas BOUTET Cc : <[email protected]>; <[email protected]> Objet : Re: [mapserver-users] Runtime Substitution bug If you take var. substitution out of it by hard coding an idblock value does the space still matter? Steve Sent from my iPad On Sep 15, 2011, at 11:07 AM, "Nicolas BOUTET" <[email protected]> wrote: Hello, 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. I have a LAYER where the data source if defined like this : CONNECTIONTYPE OGR CONNECTION "OCI:…/….@gti5500" DATA "SELECT idblock, entitiesMbr FROM block WHERE idblock = %idBlock% " Please note that there is a space character at the end of the SQL statement, after the variable to substitute. All is working fine while the space is still here. 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. Of course, the layer contains also a validation block like this: VALIDATION idblock '^[0-9]{1,6}$' END It seems that this is a bug in variable substitution. Can you confirm this? Have you already observe this kind of issue? Regards Nicolas _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
_______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
