[mapserver-users] Runtime Substitution bug

[Nicolas BOUTET]

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:sdlime at gmail.com] 
Envoyé : jeudi 15 septembre 2011 20:47
À : Nicolas BOUTET
Cc : <mapserver-users at lists.osgeo.org>; <mapserver-dev at lists.osgeo.org>
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" <nicolas.boutet at geosys.com> 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:…/…. at 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
mapserver-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20110916/5e4cf713/attachment.html