<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial, helvetica, sans-serif;font-size:10pt"><DIV>Dear Members,</DIV>
<DIV> </DIV>
<DIV>I am a newbie for development of MapServer application. I have a problem about to retrieve geo spatial data from PostGre to show on map. I want to show some rows from a table.</DIV>
<DIV> </DIV>
<DIV>for example, there are 100 rows with geospatial data in a table. I only want to show 10 rows on map without removing other rows. please suggest me.</DIV>
<DIV> </DIV>
<DIV>Please see the followings. I </DIV>
<DIV> </DIV>
<DIV>LAYER #Confidence<BR> CONNECTIONTYPE postgis<BR> NAME "firepoint"<BR> CONNECTION "user=postgres password=1234 dbname=hotspot_db host=localhost port=5432"<BR> DATA "the_geom from hotspot_tmp "<BR> TOLERANCE 3<BR> STATUS ON<BR> TYPE POINT<BR> CLASSITEM "f_posibl"<BR> TEMPLATE '/ms4w/projects/hotspot/htdocs/templates/HFVS.html'<BR> CLASS<BR> NAME "Low"<BR> EXPRESSION ([f_posibl] < 40)<BR> STYLE<BR> COLOR 255 255 0 <BR> SYMBOL "square"<BR> OUTLINECOLOR 0 0 0<BR> SIZE 5<BR> END<BR> END<BR> CLASS<BR> NAME "Moderate"<BR> EXPRESSION (([f_posibl] > 40) and ([f_posibl] < 70))<BR> STYLE<BR> COLOR 255 155
55 <BR> SYMBOL "square"<BR> OUTLINECOLOR 0 0 0<BR> SIZE 5<BR> END <BR> END<BR> CLASS<BR> NAME "High"<BR> EXPRESSION ([f_posibl] > 70)<BR> STYLE<BR> COLOR 255 0 0 <BR> SYMBOL "square"<BR> OUTLINECOLOR 0 0 0<BR> SIZE 5<BR> END <BR> END<BR>END</DIV>
<DIV> </DIV>
<DIV>Thanks.</DIV>
<DIV> </DIV>
<DIV>Win Myint Aung</DIV></div><br>
<hr size=1>Now that's room service! <a href="http://travel.yahoo.com/hotelsearchpage;_ylc=X3oDMTFtaTIzNXVjBF9TAzk3NDA3NTg5BF9zAzI3MTk0ODEEcG9zAzIEc2VjA21haWx0YWdsaW5lBHNsawNxMS0wNw--
">Choose from over 150,000 hotels <br>in 45,000 destinations on Yahoo! Travel</a> to find your fit.</body></html>