[mapserver-users] LABEL - POSITION and FONT Calculations

[Donald Kerr]

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