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

[Mark Volz]

Bobb,

Out of curiosity did you try running the query through ArcGIS or QGIS to make sure that PostGIS is returning the AQUTIME in the format you need?


Sincerely,
Mark Volz, GISP



> -----Original Message-----
> From: mapserver-dev-bounces at lists.osgeo.org [mailto:mapserver-dev-
> bounces at lists.osgeo.org] On Behalf Of mapserver-dev-request at lists.osgeo.org
> Sent: Friday, May 29, 2015 2:00 PM
> To: mapserver-dev at lists.osgeo.org
> Subject: mapserver-dev Digest, Vol 88, Issue 6
> 
> Send mapserver-dev mailing list submissions to
> 	mapserver-dev at lists.osgeo.org
> 
> To subscribe or unsubscribe via the World Wide Web, visit
> 	http://lists.osgeo.org/mailman/listinfo/mapserver-dev
> or, via email, send a message with subject or body 'help' to
> 	mapserver-dev-request at lists.osgeo.org
> 
> You can reach the person managing the list at
> 	mapserver-dev-owner at lists.osgeo.org
> 
> When replying, please edit your Subject line so it is more specific than "Re:
> Contents of mapserver-dev digest..."
> 
> 
> Today's Topics:
> 
>    1. trying to get a data from postgres in mapfile,	no joy!!
>       (Basques, Bob (CI-StPaul))
>    2. Re: trying to get a data from postgres in mapfile, no joy!!
>       (Simon Mercier)
>    3. Re: trying to get a data from postgres in mapfile, no joy!!
>       (Basques, Bob (CI-StPaul))
> 
> 
> ----------------------------------------------------------------------
> 
> Message: 1
> Date: Thu, 28 May 2015 21:14:51 +0000
> From: "Basques, Bob (CI-StPaul)" <bob.basques at ci.stpaul.mn.us>
> To: "mapserver-dev at lists.osgeo.org" <mapserver-dev at lists.osgeo.org>
> Subject: [mapserver-dev] trying to get a data from postgres in
> 	mapfile,	no joy!!
> Message-ID: <F6588035-C7C5-4B49-933F-4E368F6E5FFD at ci.stpaul.mn.us>
> Content-Type: text/plain; charset="utf-8"
> 
> 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