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

Basques, Bob (CI-StPaul) bob.basques at ci.stpaul.mn.us
Fri May 29 07:34:29 PDT 2015


Tried that, symbol definition error:

 getString(): Symbol definition error. Parsing error near ('Time:'+'[acqtime]'):(line 565) 


also tried caps, no/caps, etc. . . .
. . . .

bobb




> On May 28, 2015, at 5:06 PM, Simon Mercier <smercier at mapgears.com> wrote:
> 
> 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
> 
> _______________________________________________
> mapserver-dev mailing list
> mapserver-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-dev



More information about the mapserver-dev mailing list