[mapguide-users] Case Statement in Tool tip field

[GordonL]

Hi, there are a few workarounds for this one:
1. Create a thematic layers based on TYPE_POLUTION and hard-code text into
the labels.
2. Create multiple layers filtered on TYPE_POLUTION
3. Create a lookup table in a database (i.e. Access) and join it to your
data for tooltips based on TYPE_POLUTION

regards
gordon


marius.360 wrote:
> 
> Hi All,
> 
> I am wondering, is it possible to use a case statement in the Tool tip
> field when setting up a layer in Mapguide Studio? The table the layer
> reads from has numeric values in a column, and I want to display a string
> value corresponding to the numeric value, the case statement I use is: 
> 
> CASE WHEN "TYPE_POLLUTION" = '1' THEN 'Smoke' WHEN "TYPE_POLLUTION" = '2'
> THEN 'Rubbish' END
> 
> Now I don't get an error when checking the validity of the statement, but
> the tool tip doesn't display on my map. And this statement does return the
> correct values when used in a select statement in Oracle. Does anyone have
> a different way to accomplish this?
> 
> Kind Regards,
> 
> Marius
> 

-- 
View this message in context: http://n2.nabble.com/Case-Statement-in-Tool-tip-field-tp3174284p3220384.html
Sent from the MapGuide Users mailing list archive at Nabble.com.