[postgis-users]CONNECTION to database thru Mapserver

[strk at refractions.net]

On Mon, Mar 14, 2005 at 08:20:55AM -0800, w m wrote:
> Hi,
> I created a Mapserver layer definition in order to establish a connection to my database. I would like to display the data from the database on my map.
> The table spots has just points in the "the_geom" column. All I want to do is to display those points on the map.  When I write my layer definition, it gives me no errors but it also doesnt display those points on the map.
>   
> Here is my layer definition:
>  
> LAYER
>         CONNECTIONTYPE postgis
>         NAME "Spots"  # my table name
>         CONNECTION "user=test password=test dbname=MyDataBase host=http://localhost"

host=localhost
also, try adding a SIZE to your class
--strk;

>         DATA "the_geom FROM Spots"   # the_geom column from table Spots
>         STATUS ON
>         TYPE POINT 
>                 CLASS
>                         COLOR 0 0 0
>                         OUTLINECOLOR 0 0 0 
>                 END
> END 
>  
> Thank You
> Wokar
> 
> 		
> ---------------------------------
> Do you Yahoo!?
>  Yahoo! Small Business - Try our new resources site! 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users