[mapserver-users] Runtime Substitution bug

[Steve.Toutant at inspq.qc.ca]

Have a look at this ticket
http://trac.osgeo.org/mapserver/ticket/3999

Perhaps it is a similar issue. Maybe try to change your variable name 
idblock




"Nicolas BOUTET" <nicolas.boutet at geosys.com>@lists.osgeo.org 
Envoyé par : mapserver-users-bounces at lists.osgeo.org
2011-09-16 03:37

A
"'Steve Lime'" <sdlime at gmail.com>
cc
mapserver-users at lists.osgeo.org
Objet
RE: [mapserver-users] Runtime Substitution bug








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
_______________________________________________
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/d1e9076a/attachment.htm>