try DATA the_geom from (select id,the_geom from pointlayer where date='12/2/2008') as foo using unique id using srid=xxxx
-- thomas On Mon, Dec 15, 2008 at 06:32, Venkat Rao Tammineni <[email protected]> wrote: > Dear All, > > > > I want get data based on Date. When I run query select * from > PointLayer where news_date ='12/2/2008'; in postgre Query builder , it is > working fine. > > > > When I try "the_geom from PointLayer where news_date='12/2/2008'" I am > not getting data(map).I don't know how to send date parameter.is it > possible ?if it is ..please let me know. > > > > Advanced thanks > > > > Venkat. > > _______________________________________________ > mapserver-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapserver-users > > _______________________________________________ mapserver-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapserver-users
