Steve, >> The question is: Is it possible to take the values from the database and >> convert them for use within the LABEL e.g. 2 = ul = "POSITION ul" or 5 = uc >> = "POSITION uc"?
> At the moment POSITION is not bindable. If you file a bug then that can be changed. Once changed > you could use a PostgreSQL case statement to map your position codes to MapServer values (e.g. > 1 => UL or whatever). >> I would also like to be able to change the Font based on [fontnumber] from >> the database e.g. 0 = Arial = "FONT arial" or 1 = Times = "FONT times" > Fonts are bindable so you'd just need a case statement to map your codes to font names that > MapServer recognizes. Is it possible to create the case statement in MapServer e.g. "SELECT Geom FROM (<CASE SELECT IN HERE>) USING UNIQUE oid"? If you have any experience of doing this can you pen a quick example for me please? Many thanks. Regards, Donald _______________________________________________ mapserver-users mailing list mapserver-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapserver-users