[mapserver-users] couldn't adapt this postgis query

[Ahmet Temiz]

hello

I couldn't adapt this postgis query to mapserver.  Nothing is displayed.
it gives normally output as point data in console and displayed in JUMP.

What am I doing wrong?

    NAME 'faultBufferRoad'
      TYPE POINT
      #DUMP true
      TEMPLATE fooOnlyForWMSGetFeatureInfo

      EXTENT 2858992.767241 4274930.071479 4987500.356728 5175507.464287

     CONNECTIONTYPE POSTGIS
     CONNECTION "host=localhost port=5432 dbname=tr3 user=orkun
password=222222"

     DATA " geom from  ( SELECT road.gid as gid , road.tipi as tipi,
ST_Transform(ST_LineInterpolatePoint(road.the_geom::geometry,0.5),3857) as
geom FROM road4analyse_geog as road  INNER JOIN fault4analyse_geog AS fault
 ON ST_DWithin(road.the_geom, fault.the_geom, 100,false ) AND (
fault.the_geom IS NOT NULL or road.the_geom IS NOT NULL ) ) as foo  using
unique gid using srid=3857 "

     PROCESSING "CLOSE_CONNECTION=DEFER"

      METADATA
        'ows_title' 'faultBufferRoad'
      END
      STATUS OFF
      #TRANSPARENCY ALPHA
      OPACITY 90

      PROJECTION
        "init=epsg:3857"
      END
      #SYMBOLSCALEDENOM 100000

      CLASSITEM 'tipi'

      CLASS
        NAME "Class1"
        STYLE
          #SYMBOL "circle"
          SIZE 50
          COLOR 0 0 200
        END
      END

END # LAYER

regards


-- 
Ahmet Temiz
Jeoloji Müh.
Afet ve Acil Durum Yönetimi Başkanlığı
Bilgi İşlem  Dairesi Başkanlığı-CBS Grubu


________________________

Ahmet Temiz
Geological Eng.
Information Systems - GIS Group
Disaster and Emergency Management
of Presidency
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/mapserver-users/attachments/20161107/35793d28/attachment.htm>