Hi All,<br><br>I am using geomoose2 framework + ms4w + postgresql 9.0 and postgis 1.5.<br><br>While my mapscript use DATA  from shape file and / or from mysql table ,map is generated and displayed well.<br>but when it fetch from postgresql it fails to generate map. I am not getting any error message.<br>
<br>Please help to find my problem.I am new in this area. I gave bellow my mapscript for shape,mysql and postgis.<br><br>read from shape:-<br>----------------------------------------------------------------<br>MAP<br>    NAME &quot;Internal_plots&quot;<br>
    STATUS ON<br>    TRANSPARENT ON<br>    INCLUDE &quot;../../../geomoose_globals.map&quot;<br>    LEGEND<br>        STATUS ON<br>        LABEL<br>        TYPE TRUETYPE<br>        FONT vera_sans<br>        SIZE 8<br>        COLOR 0 0 0<br>
        END        <br>    END    <br>       LAYER<br>            NAME Internal_plots<br>          STATUS ON<br>            TYPE POLYGON<br>            LABELITEM &#39;DAG_NO&#39;<br>          TRANSPARENCY 100        <br>            LABELCACHE ON<br>
            CLASSITEM &#39;DAG_NO&#39;<br>          DATA &#39;./Internal_plots&#39; <br>          CLASS<br>            NAME &#39;dag_no&#39;<br>            STYLE<br>                SYMBOL &#39;plainline&#39;<br>                SIZE 1<br>
                COLOR 255 255 255<br>                OUTLINECOLOR 0 0 0<br>            END<br>            LABEL<br>                TYPE TRUETYPE<br>                FONT vera_sans<br>                SIZE 10<br>                ANTIALIAS TRUE<br>
                COLOR -1 -1 -1<br>                OUTLINECOLOR -1 -1 -1<br>                BUFFER 4<br>                MINFEATURESIZE auto<br>                PARTIALS FALSE<br>                POSITION cc<br>            END<br>
          END<br>          METADATA<br>              &#39;identify_record&#39;    &#39;../../Common/Template/village/identify_village.html&#39;<br>            &#39;peak_record&#39;    &#39;../../Common/Template/village/village_peak.html&#39;<br>
              &#39;select_record&#39;        &#39;../../Common/Template/village/select_village.html&#39;<br>            &#39;select_header&#39;     &#39;../../Common/Template/village/select_header_village.html&#39;<br>            &#39;popups&#39;             &#39;../../Common/Template/village/village_popup.html&#39;<br>
            &#39;itemquery&#39;            &#39;../../Common/Template/village/village_itemquery.html&#39;<br>        #    &#39;itemquery-filteritem&#39; &#39;OWNER_NAME&#39;<br>            &#39;itemquery-filter&#39;    &#39;/.*[qstring].*/i&#39; <br>
            &#39;qstring_validation_pattern&#39; &#39;.&#39;<br>            <br>            # Feature reports are stored in the conf/feature_report directory.<br>            &#39;feature_report&#39;     &#39;village.shp.xml&#39;<br>
          END<br>          TOLERANCE 0<br>        END  <br>END ## end Map<br><br><br>### report:  work well<br>----------------------------------------------------------------<br><br>Read from mysql , only DATA section,rest all are same<br>
-------------------------------------------------------------------------------<br> CONNECTIONTYPE OGR<br> CONNECTION &quot;MySQL:bmaapp,user=root,password=root,port=3306&quot;<br>  DATA &quot;SELECT * from internal_plots  ;&quot;<br>
<br>### report:  work well<br>----------------------------------------------------------------<br>
<br>
Read from postGIS only DATA section,rest all are same<br>
-------------------------------------------------------------------------------<br> 
CONNECTIONTYPE postgis<br>   CONNECTION &#39;host=localhost port=5432 dbname=postgis user=postgres password=root@2011&#39;<br>   DATA &#39;the_geom from Internal_plots&#39;<br><br><br>### report:  map is not displayed<br>
---------------------------------------------------------<br><br>please note that from pgadmin III sql query  if we give  select the_geom from public.&quot;Internal_plots&quot;  then  gives the geomtry column as output but only    select the_geom from Internal_plots OR   the_geom from Internal_plots    does not give output rather second one is syntax error and first one is giving message that Internal_plots relation does not exist.<br>
<br><br><br>With Thanks and best regards<br>Sanjib Chatterjee<br><br><br>
<br>