[mapserver-users] layerObj.setFilter parser error
If I use layerObj.setFilter ( "(point.id = 1)" ), mapObj.OWSDispatch gives an error: "msTokenizeExpression(): Expression parser error. Parsing time value failed. msParseTime(): Regular expression error. Unrecognized date or time format ()." It works correctly with layerObj.setFilter ( "( id = 1)" ) or layerObj.setFilter ( "point.id = 1" ). FILTER "( point.id = 1 )" in mapfile also works. This is of course only a simple example, I need both fully qualified column name and parenthesis. It seems to be a bug. Do you know any simple trick, how to get it working for a presentation tomorrow morning? Version 6.0.1. Thanks Radim ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] layerObj.setFilter parser error
I don't know of a simple work around. MapScript and the mapfile parser use the same expression tokenizing routine. What happens if you try single quotes? That is: layerObj.setFilter ( '(point.id = 1)' ) Steve -Original Message- From: mapserver-users-boun...@lists.osgeo.org [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Radim Blazek Sent: Tuesday, January 10, 2012 12:05 PM To: mapserver-users@lists.osgeo.org Subject: [mapserver-users] layerObj.setFilter parser error If I use layerObj.setFilter ( "(point.id = 1)" ), mapObj.OWSDispatch gives an error: "msTokenizeExpression(): Expression parser error. Parsing time value failed. msParseTime(): Regular expression error. Unrecognized date or time format ()." It works correctly with layerObj.setFilter ( "( id = 1)" ) or layerObj.setFilter ( "point.id = 1" ). FILTER "( point.id = 1 )" in mapfile also works. This is of course only a simple example, I need both fully qualified column name and parenthesis. It seems to be a bug. Do you know any simple trick, how to get it working for a presentation tomorrow morning? Version 6.0.1. Thanks Radim ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] layerObj.setFilter parser error
On Thu, Jan 12, 2012 at 12:18 AM, Lime, Steve D (DNR) wrote: > I don't know of a simple work around. MapScript and the mapfile parser use > the same expression tokenizing routine. What happens if you try single > quotes? That is: > > layerObj.setFilter ( '(point.id = 1)' ) Single quotes don't help. I have discovered that the problem is key (?) word 'point', "pokus.id = 1" for example, and other table names work well. As a work around I was able to use "true and (point.id = 1)". Radim > Steve > > -Original Message- > From: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Radim Blazek > Sent: Tuesday, January 10, 2012 12:05 PM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] layerObj.setFilter parser error > > If I use layerObj.setFilter ( "(point.id = 1)" ), mapObj.OWSDispatch > gives an error: > > "msTokenizeExpression(): Expression parser error. Parsing time value > failed. > msParseTime(): Regular expression error. Unrecognized date or > time format ()." > > It works correctly with layerObj.setFilter ( "( id = 1)" ) or > layerObj.setFilter ( "point.id = 1" ). > FILTER "( point.id = 1 )" in mapfile also works. > This is of course only a simple example, I need both fully qualified > column name and parenthesis. > > It seems to be a bug. Do you know any simple trick, how to get it > working for a presentation tomorrow morning? > > Version 6.0.1. > > Thanks > Radim > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
RE: [mapserver-users] layerObj.setFilter parser error
Good catch, that's an obscure bug. Can you file a ticket? Steve From: Radim Blazek [radim.bla...@gmail.com] Sent: Saturday, January 14, 2012 7:47 AM To: Lime, Steve D (DNR) Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] layerObj.setFilter parser error On Thu, Jan 12, 2012 at 12:18 AM, Lime, Steve D (DNR) wrote: > I don't know of a simple work around. MapScript and the mapfile parser use > the same expression tokenizing routine. What happens if you try single > quotes? That is: > > layerObj.setFilter ( '(point.id = 1)' ) Single quotes don't help. I have discovered that the problem is key (?) word 'point', "pokus.id = 1" for example, and other table names work well. As a work around I was able to use "true and (point.id = 1)". Radim > Steve > > -Original Message- > From: mapserver-users-boun...@lists.osgeo.org > [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Radim Blazek > Sent: Tuesday, January 10, 2012 12:05 PM > To: mapserver-users@lists.osgeo.org > Subject: [mapserver-users] layerObj.setFilter parser error > > If I use layerObj.setFilter ( "(point.id = 1)" ), mapObj.OWSDispatch > gives an error: > >"msTokenizeExpression(): Expression parser error. Parsing time value > failed. > msParseTime(): Regular expression error. Unrecognized date or > time format ()." > > It works correctly with layerObj.setFilter ( "( id = 1)" ) or > layerObj.setFilter ( "point.id = 1" ). > FILTER "( point.id = 1 )" in mapfile also works. > This is of course only a simple example, I need both fully qualified > column name and parenthesis. > > It seems to be a bug. Do you know any simple trick, how to get it > working for a presentation tomorrow morning? > > Version 6.0.1. > > Thanks > Radim > ___ > mapserver-users mailing list > mapserver-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users
Re: [mapserver-users] layerObj.setFilter parser error
Unfortunately I found a similar problem with parser if PolygonFromText is used in filter. I filled a ticket http://trac.osgeo.org/mapserver/ticket/4158 Radim On Sun, Jan 15, 2012 at 4:27 PM, Lime, Steve D (DNR) wrote: > Good catch, that's an obscure bug. Can you file a ticket? > > Steve > > > From: Radim Blazek [radim.bla...@gmail.com] > Sent: Saturday, January 14, 2012 7:47 AM > To: Lime, Steve D (DNR) > Cc: mapserver-users@lists.osgeo.org > Subject: Re: [mapserver-users] layerObj.setFilter parser error > > On Thu, Jan 12, 2012 at 12:18 AM, Lime, Steve D (DNR) > wrote: >> I don't know of a simple work around. MapScript and the mapfile parser use >> the same expression tokenizing routine. What happens if you try single >> quotes? That is: >> >> layerObj.setFilter ( '(point.id = 1)' ) > > Single quotes don't help. > > I have discovered that the problem is key (?) word 'point', "pokus.id > = 1" for example, and other table names work well. > > As a work around I was able to use "true and (point.id = 1)". > > Radim > > >> Steve >> >> -Original Message- >> From: mapserver-users-boun...@lists.osgeo.org >> [mailto:mapserver-users-boun...@lists.osgeo.org] On Behalf Of Radim Blazek >> Sent: Tuesday, January 10, 2012 12:05 PM >> To: mapserver-users@lists.osgeo.org >> Subject: [mapserver-users] layerObj.setFilter parser error >> >> If I use layerObj.setFilter ( "(point.id = 1)" ), mapObj.OWSDispatch >> gives an error: >> >> "msTokenizeExpression(): Expression parser error. Parsing time value >> failed. >> msParseTime(): Regular expression error. Unrecognized date or >> time format ()." >> >> It works correctly with layerObj.setFilter ( "( id = 1)" ) or >> layerObj.setFilter ( "point.id = 1" ). >> FILTER "( point.id = 1 )" in mapfile also works. >> This is of course only a simple example, I need both fully qualified >> column name and parenthesis. >> >> It seems to be a bug. Do you know any simple trick, how to get it >> working for a presentation tomorrow morning? >> >> Version 6.0.1. >> >> Thanks >> Radim >> ___ >> mapserver-users mailing list >> mapserver-users@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapserver-users >> >> > > ___ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users