Am 23.11.2012 14:30, schrieb Lars Lingner: >> Hi Lars, >> >> thanks for the information! >> >> It works fine for the label. >> >> Before I defined LABELITEM mycolumn and got the long notation: >> 2.54000000000e+000 >> >> with definition TEXT mycolumn the label looks fine (without using any >> function): 2.54 >> >> Is there a solution for the query result too? >> > I assume that you cant use any of these functions in your template file. > Would be nice if I'm wrong. > > An workaround could be to use the ogr connection type. This way, you can > access and modify your features/attributes with SQL. > > Look at example #4 here [1]. I think you can use "SELECT ..., > round(numbercolumn,2) as mycolumn FROM..." here. > > But than... if the performance isn't good enough, it might me worth to > just preprocess the shape files. Or put them in a database to be more > flexibel. > > > Lars > > > [1] > http://mapserver.org/input/vector/ogr.html#examples-of-layer-definitions-using-ogr > > ____________ Hi Lars,
again - thanks for your answer. I got a solution. CONNECTIONTYPE OGR CONNECTION "double_test.shp" DATA "Select *, J_2010_201*1 as newcolumn from double_test" The function round(numbercolumn,2) was not found but with multiplication by 1 it works. Astrid _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
