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

[Simon Mercier]

Hi Bob,  try TEXT ('Time: '+'[acqtime]')

-- 
Simon Mercier



On 15-05-28 05:14 PM, Basques, Bob (CI-StPaul) wrote:
> 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
>
>
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev

-- 
Simon Mercier
vp solutions mapgears
tel: +1.418.476.7139 p101

LinkedIn : http://ca.linkedin.com/in/simonmercier
Twitter : http://twitter.com/simonmercier