[mapserver-dev] trying to get a data from postgres in mapfile, no joy!!

[Basques, Bob (CI-StPaul)]

All,

I’m trying to do something seemingly simple, but . . .


	LAYER
   		NAME 'disclaimer1'
   		STATUS DEFAULT
   		TYPE point

		INCLUDE "./etc/plots_db.inc"

		DATA "the_geom, to_char(now(), 'HH24:MI:SS') acqtime from loc_last limit 1"

   		TRANSFORM ll
		UNITS pixels

		LABELITEM "ACQTIME"
   		FEATURE
    			POINTS
     				60 -25
    			END
    			TEXT ’Time: [ACQTIME]'
    			#TEXT 'Time:'
   		END
   		CLASS
     			STYLE
			END
    			LABEL
				TYPE trueTYPE
				FONT arial-bold
				FORCE TRUE
				COLOR 0 0 0
     				STYLE
					GEOMTRANSFORM 'labelpoly'
					COLOR 255 255 1
				END
				BUFFER 5
				SHADOWSIZE 1 1
				SIZE 20
     			END
    		END
   	END

I keep getting “Time: [ACQTIME]” as the label, I can’t seem to get the current time output from the call to posts.

I’m trying to apply a timestamp label to the corner of an image.

No error, just no timestamp.  Maybe there’s another build in way??

Thanks

bobb