[postgis-devel] postgis connection problem..help!!!

[syera]

hello..i have a problem with my postgis connection. Before this i just use
shapefile layer.It works, but because i have to add search lot service, i
need to use postgis connection. But when i add the code in my mapfile, the
pink layer appear not my layer. I just want to know are there any problem
with my mapfile or i need to change somewhere?? 

Below is the example of my mapfile:



MAP
NAME 'jalan'
SIZE 800 650
STATUS ON
EXTENT 34032.192641 -68039.619352 50245.218355 -57248.649087

UNITS METERS

INCLUDE "../../geomoose_globals.map"

WEB
INCLUDE "../../temp_directory.map"
END

LEGEND
STATUS ON
LABEL
TYPE TRUETYPE
FONT vera_sans
SIZE 8
COLOR 0 254 0
END
END

LAYER

CONNECTIONTYPE postgis
CONNECTION "dbname=postgis host=localhost user=postgres password=admin
port=5432"
DATA "the_geom FROM JALAN"
#DATA './jalan.shp'
NAME 'jalan'
TYPE LINE
STATUS ON

CLASS
NAME 'jalan'
STYLE
SYMBOL 'plainline'
SIZE 1
COLOR 200 0 255
END
END

PROJECTION
"proj=cass"
"lat_0=2.121679744444445"
"lon_0=103.4279362361111"
"x_0=-14810.562"
"y_0=8758.32"
"ellps=GRS80"
"units=m"
"no_defs"

"init=epsg:4326"
"init=epsg:4269"
"init=epsg:900913"

END

TOLERANCEUNITS FEET
TOLERANCE 200


END

END ## end Map
-- 
View this message in context: http://old.nabble.com/postgis-connection-problem..help%21%21%21-tp27997157p27997157.html
Sent from the PostGIS - Dev mailing list archive at Nabble.com.