[mapserver-users] Problem with postgis layer

[Twan Kogels]

Hi,

I have got a strange problem with a postgis layer in mapserver 3.5. A 
example to illustrate my problem: the following layer definition works:

LAYER
   CONNECTIONTYPE postgis
   NAME "poi_layer"

   # Connect to a remote spatial database
   CONNECTION "user=postgres dbname=food host=10.0.0.2"
   # Get the lines from the 'geom' column of the 'roads' table
   DATA "the_geom from pc6punten"
   FILTER "pc6 like '1797%'"
   STATUS ON
   TYPE POINT
   CLASSITEM "pc6"
   CLASS
     TEMPLATE "ttt_query.html"
     SYMBOL 2
     SIZE 8

     COLOR 0 0 0
   END
   TOLERANCE 5
END

but when i try the following layer definition:

LAYER
   CONNECTIONTYPE postgis
   NAME "poi_layer"

   # Connect to a remote spatial database
   CONNECTION "user=postgres dbname=food host=10.0.0.2"
   # Get the lines from the 'geom' column of the 'roads' table
   DATA "p.the_geom from pc6punten p"
   FILTER "p.pc6 like '1797%'"
   STATUS ON
   TYPE POINT
   CLASSITEM "pc6"
   CLASS
     TEMPLATE "ttt_query.html"
     SYMBOL 2
     SIZE 8

     COLOR 0 0 0
   END
   TOLERANCE 5
END

The layer doesn't return any results. Does anyone know what i'm doing wrong?

Thanks,
-twan

-- 
http://www.twansoft.com