[mapserver-users] find_srid of a complex join DATA statement in postgresql layer

[Burgholzer, Robert (DEQ)]

I have a join query that is used to fuel a DATA statement, and it works on the command line, and inside of mapserver as it is grabbing the data, but when it goes to rendering the final geometry it fails because it cannot seem to determine what table name to look for in the find_srid statement:  find_srid('','(select','poly_geom')  .  Am I running up against some complexity limitation of mapserver, or making some mistake in my DATA query?

DATA "poly_geom FROM (select foo.poly_geom, foo.elemname,foo.elementid, foo.dataval as dataval_%runid1%, bar.dataval as dataval_%runid2%, round(((bar.dataval - foo.dataval) / foo.dataval)::numeric,4) as delta_pct from (select a.poly_geom, b.elementid, a.scenarioid, a.elemname, a.custom1, a.custom2, b.runid, b.dataname, b.dataval, b.datatext from scen_model_element as a left outer join scen_model_run_data as b on ( a.elementid = b.elementid) left outer join scen_model_element as c on (c.scenarioid = %pscen% and c.custom1 in ('cova_ws_subnodal', 'cova_ws_container') and contains(c.poly_geom,a.point_geom) ) where a.scenarioid = %nscen% and b.runid = %runid1% and b.dataname = '%dataname1%' ) AS foo, (select d.poly_geom, e.elementid, d.scenarioid, d.elemname, d.custom1, d.custom2, e.runid, e.dataname, e.dataval, e.datatext from scen_model_element as d left outer join scen_model_run_data as e on ( d.elementid = e.elementid) left outer join scen_model_element as f on (f.scenarioid = %pscen% and f.custom1 in ('cova_ws_subnodal', 'cova_ws_container') and contains(f.poly_geom,d.point_geom) ) where d.scenarioid = %nscen% and e.runid = %runid2% and e.dataname = '%dataname2%' ) AS bar where foo.elementid = bar.elementid ) AS foobar USING UNIQUE elementid"

Robert  Burgholzer
Surface Water Modeler
Virginia DEQ Office of Surface and Ground Water Supply
804-869-3066

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20130815/7fe10042/attachment.htm>