postgis using COLLECT() in layer data...

[John Cole]

Hello,
  I'm trying to un-clutter street labels by using a COLLECT() and grouping
on the street name, but I'm running into a problem getting MapServer 4.4 to
work with the data line.

Here is my layer

	LAYER
		NAME Highways_anno
		STATUS default
		GROUP roads
		CONNECTIONTYPE postgis
		CONNECTION "user=mapserver password=mapserver
dbname=florence host=localhost" 
		DATA "the_geom from (select collect(the_geom) as the_geom,
rd_name from tgr_roads group by rd_name) AS new_table USING UNIQUE rd_name
USING SRID=-1"
		TYPE annotation
		LABELITEM "rd_name"
		MAXSCALE 12000
	
		CLASS
			LABEL
				COLOR 0 0 0
				TYPE TRUETYPE
				ANGLE AUTO
				FONT arial
				SIZE 8
				ANTIALIAS TRUE
				POSITION CC
				MINDISTANCE 10
				BUFFER 5
			END
		END
	END

The query returns, but no labels are drawn.  Using a DATA "the_geom from
tgr_roads" does draw labels.

What am I doing wrong? :-)

Thanks,

John Cole

-------------------------------------
This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.