Hi,<br> i just want to place a dynamic object in map using POSTGRESQL.<br> when i place an object statically using POINT in mapfile,i am getting a point as specified in <b>attachment</b> please see that too<br><br> but when i want to place the same object dynamically i am not able to do that,<br>
For that i have created one table in postgresql as shown below<br><br><b>create table geometry(geom varchar,srid int);<br>insert into geometry values('POINTS(0 0)',2);<br>select * from geometry;<br> geom | srid <br>
------------+------<br> POINT(0 0) | 2<br><br><br></b>i have linked the above database using mapfile as<br><br><b># This is our "Dynamic Object" mapfile<br>NAME "object"<br>SIZE 800 600<br>IMAGECOLOR 249 245 186<br>
IMAGETYPE png<br>EXTENT -1.00 -1.00 1.00 1.00<br>WEB<br>TEMPLATE "/opt/fgs/www/htdocs/db.html"<br>IMAGEPATH "/opt/fgs/www/htdocs/tmp/"<br>IMAGEURL "/tmp/"<br>END<br>LAYER<br>NAME "data" <br>
CONNECTIONTYPE POSTGIS<br>NAME "postgres"<br>CONNECTION "host=localhost port=5432 dbname=postgres user=postgres password=hellopostgres "<br>DATA "geom from geometry"<br>STATUS ON<br>TYPE POINT<br>
CLASS<br>STYLE<br>#SYMBOL 'circle'<br>SIZE 30<br>COLOR 229 100 225<br>END<br>END<br>FEATURE<br>END<br>END<br> SYMBOL<br> TYPE ellipse<br> FILLED true<br>POINT <br> 10 10 <br> END<br> END<br>
END<br>END<br>END<br>END<br>END<br></b><br>i am not getting any point on the map, it shows only the blank image without point.<br><br>will anyone help me to overcome this problem and make me clear my connection is correct<br>
<br>thanks<br><br>Regards <br>SHADAB<br>