Dear Thomas, I have done with my task. Here the thing is we need to have all the field members with in the Query. Thanks for great response.
Here is my Code:- Data "the_geom from (select gid,test,date,class,the_geom from globalnews where date='12/2/2008') as Foo USING UNIQUE gid USING 'SRID=3000'" Thanks, Venkat. -----Original Message----- From: thomas bonfort [mailto:[email protected]] Sent: Monday, December 15, 2008 11:57 AM To: Venkat Rao Tammineni Cc: [email protected] Subject: Re: [mapserver-users] How to get data based on Date in Postgresql/PostGIS 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
