[mapserver-dev] Re: [mapserver-users] Runtime Substitution bug

[Steve Lime]

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-dev/attachments/20110915/a70b9ef0/attachment.html