Hi everybody,<div><br></div><div>thanks for your replies.</div><div><br></div><div>the issue was latters with upper cases. so i have to import my tables tables again and make all small laters and the change the map file to small laters.</div>
<div><br></div><div>I<br><br><div class="gmail_quote">On 19 May 2011 21:09, Micha Silver <span dir="ltr"><<a href="mailto:micha@arava.co.il">micha@arava.co.il</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">


  
    
  
  <div style="direction:ltr" bgcolor="#ffffff" text="#000000"><div class="im">
    <p style="margin-bottom:0cm;margin-top:0pt">On 05/18/2011 09:28
      AM, Langen Mallya wrote:<br>
    </p>
    <blockquote type="cite">
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        Hi everybody,</div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        <br>
      </div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        I have a question about MapServer and PostGIS.</div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        <br style="line-height:1.2em;outline-style:none">
      </div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        Im working on a project which involves OpenSource. I have
        managed to plot nearly all layers except three. after 1 month of
        trying there is no hope for these 3 layers to display, but the
        layers are loaded well in QGIS.</div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        <br style="line-height:1.2em;outline-style:none">
      </div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        I have tried to delete the layers and load it again in the
        server, still the same problem.</div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        <br>
      </div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        see the mapserver layer code below and for regions(fails to
        display) & Intl. boundaries (Display well)</div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        <br>
      </div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        <br>
      </div>
      <div style="border-collapse:collapse;font-family:arial,helvetica,clean,sans-serif;font-size:13px;margin:0px;padding:0px;line-height:1.2em;outline-style:none">
        <br>
      </div>
      <div style="margin:0px;padding:0px;outline-style:none">
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">#=============================================================</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px"><br>
            </span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px"> 
              LAYER</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   
              NAME 'Region'</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   
              TYPE POLYGON</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   
              DUMP true</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   
              TEMPLATE fooOnlyForWMSGetFeatureInfo</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px"> 
              EXTENT 24.162085 -12.027731 45.340160 -0.726251</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   
              CONNECTIONTYPE postgis</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   
              CONNECTION "dbname='ttaf' host=127.0.0.1 port=5432
              user='XXXXXXX' password='XXXXXXX' sslmode=disable"</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
          <font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   
              DATA "the_geom FROM Regions"</span></font></div>
        <div style="margin:0px;padding:0px;outline-style:none">
        </div>
      </div>
    </blockquote>
    <br></div>
    Maybe the Uppercase 'R'  in Regions??<br>
    <br>
    <blockquote type="cite">
      <div style="margin:0px;padding:0px;outline-style:none">
        <div style="margin:0px;padding:0px;outline-style:none"><font face="arial, helvetica, clean,
            sans-serif"><span style="border-collapse:collapse;line-height:15px">   </span></font><br>
        </div>
      </div>
    </blockquote>
    <br>
  </div>

</blockquote></div><br><br clear="all"><br>-- <br>Langen R. M. Mallya,<br>Chief Consultant,<br>Cutlan Consultant,<br>Makuyuni, Monduli,<br>P.O.Box 16967,<br>Arusha,<br>Tanzania.<br><br>Phone #: +255-78-444-5465<br>Phone #: +255-76-866-0802<br>
Phone#: +255-71-940-6096<br>Fax #: +255-78-744-5465<br><br>e-mail: <a href="mailto:info@cutlan.co.tz">info@cutlan.co.tz</a><br>e-mail: <a href="mailto:cutlan@gmail.com">cutlan@gmail.com</a><br><a href="http://www.cutlan.co.tz">http://www.cutlan.co.tz</a><br>

</div>