[postgis-users] Help Query Layer

[Mark Cave-Ayland]

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-
> bounces at postgis.refractions.net] On Behalf Of Valentino SAVIO
> Sent: 14 March 2006 14:11
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Help Query Layer

(cut)

> I would want to execute following query:
> name, color, coord FROM siti
> And to obtain information of layer the fields [name] [color]
> The declaration of the layer is brought back.
> Someone can help me?
> thanks to all
> 
> LAYER
> 	NAME TESTDB
> 	METADATA
> 		LYRNAME "TESTDB"
> 		DESCRIPTION "description"
> 	END
> 
> 	TEMPLATE "ttt_query.html"
> 
> 
> 	CONNECTIONTYPE POSTGIS
> 	CONNECTION "host=127.0.0.1 dbname=postgres user=postgres
> password=xxxxxx"
> 	DATA "coord FROM siti as foo using unique coord using SRID=4327"
> 	STATUS ON
> 	TYPE POINT
> 
> 		CLASS
> 			COLOR 0 0 0
> 			SYMBOL 'circle'
> 			SIZE 5
> 		END
> END


Hi Valentino,

If you say that QGIS works for you then this looks like it could be an issue
with Mapserver rather than PostGIS. Have you tried posting on the Mapserver
mailing lists at http://mapserver.gis.umn.edu? Someone there should be able
to help you with your problem.


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.