[mapserver-users] LAYER LABEL ANGLE Calculation Problem

[Donald Kerr]

I am looking for some help if possible.

I am putting labels on a map and the angle is stored in database field
called "orientation". Orientation is in 10ths of degrees so I need to divide
by 10 to get degrees. I also need to offset by 90 degrees as the number
starts at east, not north. Ideally I would just like to do the following in
the LABEL definition:

ANGLE (([orientation]/10)-90)

... But it doesn't work - getting pink tiles.

ANGLE [orientation] does work but obviously the labels are NOT at the right
angle.

Here's the full layer definition:

LAYER CONNECTIONTYPE postgis
	NAME "CartographicText"
	CONNECTION "user=postgres dbname=MasterMap host=localhost"
	DATA "geom FROM cartographictext USING UNIQUE toid"
	STATUS DEFAULT
  
	MINSCALEDENOM 1
	MAXSCALEDENOM 1300

	TYPE ANNOTATION

	DEBUG ON

	LABELITEM textstring
	CLASS
		EXPRESSION ([featurecode] = 10169)
		LABEL
			TYPE truetype
			FONT arial
			SIZE 6
			COLOR  0 0 0
			OUTLINECOLOR 255 255 255
			BACKGROUNDCOLOR 255 0 0
			ANTIALIAS TRUE
			ANGLE [orientation]
		END # LABEL
	END # CLASS
END # LAYER


Regards,

Donald