On Dec 29, 2011, at 8:14 AM, ahlah <ahti.laht...@pp.inet.fi> wrote:
> Hi, > >> DATA 'ST_Simplify(geom_3067, 100) geom FROM lines USING srid=3067 USING >> UNIQUE id' > > still getting error: > > msDrawMap(): Image handling error. Failed to draw layer named 'grid'. > msPostGISLayerWhichShapes(): Query error. Error (ERROR: syntax error at or > near "geom" > LINE 1: ...id" from lines where ST_Simplify(geom_3067, 1000) geom && Ge... Dunno man. Guessing in the wind again... Create a view in Pg using a column alias as above, then use the view in the map file. That should do it. Mind it, I haven't looked at the actual syntax of your query.... I am on an iPad here. > ^ > ) executing query: select > "status",encode(AsBinary(force_collection(force_2d("ST_Simplify(geom_3067, > 1000) geom")),'NDR'),'hex') as geom,"id" from lines where > ST_Simplify(geom_3067, 1000) geom && GeomFromText('POLYGON((455103 > 7369428.2777498,455103 7564228.2777498,634903 7564228.2777498,634903 > 7369428.2777498,455103 7369428.2777498))',3067) > AL > > -- > View this message in context: > http://osgeo-org.1803224.n2.nabble.com/simplify-problem-tp7135648p7135710.html > Sent from the Mapserver - User mailing list archive at Nabble.com. > _______________________________________________ > 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