<div dir="ltr">Hmmm... Wasn't an intentional omission. If you have logging turned on and can see the resulting SQL, does the !BOX! get replaced but just incorrectly or is the !BOX! still in the SQL.</div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Aug 24, 2022 at 5:16 PM Scott <<a href="mailto:public@postholer.com">public@postholer.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">I've installed 8rc1 and I've run into an issue. I didn't see anything in <br>
the change log, so I'll put it here.<br>
<br>
The !BOX! variable that has been historically available doesn't seem to <br>
be supported with CONNECTIONTYPE POSTGIS any longer. For instance:<br>
<br>
DATA "geom from (<br>
select<br>
geom<br>
from sometable<br>
where st_intersects(geom, !BOX!)<br>
) as sq using unique geom using srid=4269"<br>
<br>
...will throw an error:<br>
<br>
<?xml version='1.0' encoding="UTF-8" standalone="no" ?><br>
<!DOCTYPE ServiceExceptionReport SYSTEM <br>
"<a href="http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd" rel="noreferrer" target="_blank">http://schemas.opengis.net/wms/1.1.1/exception_1_1_1.dtd</a>"><br>
<ServiceExceptionReport version="1.1.1"><br>
<ServiceException><br>
msDrawMap(): Image handling error. Failed to draw layer named <br>
'wptsAll'.<br>
msPostGISLayerWhichShapes(): Query error. Failed to build query SQL.<br>
msPostGISBuildSQL(): General error message. Failed to build SQL <br>
'where'.<br>
</ServiceException><br>
</ServiceExceptionReport><br>
<br>
If I remove the !BOX! it will work.<br>
<br>
Thanks!<br>
Scott<br>
<br>
--<br>
<a href="http://www.postholer.com" rel="noreferrer" target="_blank">www.postholer.com</a><br>
_______________________________________________<br>
MapServer-users mailing list<br>
<a href="mailto:MapServer-users@lists.osgeo.org" target="_blank">MapServer-users@lists.osgeo.org</a><br>
<a href="https://lists.osgeo.org/mailman/listinfo/mapserver-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/mapserver-users</a><br>
</blockquote></div>