[mapserver-users] postgis/mapserver

[gispmpf at zipmail.com.br]

Ok , but what I'm asking is if i can do it only using mapserver and its
".map" file and a database with postgis. 
I want to read the points of the line in the postgis table and create a
layer with it as in the mapfile and show this points.
Do I have to use a script language to do it?
Can a do it only using the mapfile?


> There should be syntax in the programming/scripting
> language your using to turn the Postgre "trace"
> function on. In perl the syntax is "$dbh->trace(2);"
> where $dbh is an already declared database
> handle/connection. The trace will in turn place
> information regarding your database connection (if
> there is one) in the web server log file. In apache on
> RedHat the log is usually "/var/log/httpd/error_log".
> Hope that helps.
> Lowell Filak

 --- gispmpf at zipmail.com.br wrote:
 > Hello,
 > 
 > I have another questio about mapserver/postgis
 > interface...
 > i have adapted the following script for mapserver:
 > 
 > LAYER
 > CONNECTIONTYPE postgis
 > NAME 'Roads' 
 > CONNECTION "user=postgres dbname=teste
 > host=localhost"
 > DATA "linha from teste"
 > STATUS ON
 > TYPE LINE
 > FILTER "id = 1"
 > CLASS 
 > EXPRESSION ([id]=1)
 > COLOR 255 22 22 
 > SYMBOL 0
 > SIZE 2
 > END
 > CLASS
 > # All the rest are darker and only 1 pixel wide
 > EXPRESSION ([id]>1)
 > COLOR 205 92 82 
 > END
 > END
 > my intention is to draw the lines of this database
 > in a web browser
 > but i dont have any results with it
 > How can i know if this script is realy conecting
 > with the postgis database?
 > and if it is ... how can i see what is wrong?
 > 
 > Thanks
 > João.
 > 
 > 
 > 
 > 
 >
 ___________________________________________________________
 > 
 > http://www.zipmail.com.br O e-mail que vai aonde
 > você está.
 > 
 > 
 > 



___________________________________________________________

http://www.zipmail.com.br O e-mail que vai aonde você está.