> It seems I found how to display multilevel junction of highway with "ORDER
> BY" in the case using a one layer. Adding "order by id desc" or "order by
> id asc" in subquery
> $highwayLayer->set("data","geom from (select id, 'id = '||id as name, geom
> from my_table
> where ST_Intersects(geom, !BOX!) order by id desc) as subquery using
> unique id using srid=3857");
Be careful with that as you cannot expect this to work consistently as long as
MapServer wraps it in a subquery. The database will likely return your features
either in storage order or in index order depending if it uses a sequential
scan or the index. You should not rely on an ORDER BY within a subquery...
_______________________________________________
mapserver-users mailing list
mapserver-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapserver-users
