Dear Thomas, I am not getting Point layer.I am getting blank image.Below is my query.
Data "the_geom from (select gid,the_geom from globalnews where news_date='12/2/2008') as foo using unique gid using srid=3000" I don't know what is foo? I am getting confuse on this. Globalnews is point layer and news_date is varchar type, is there any problem with that? Please let me know.give me some suggestion on this. I am waiting for your great response. 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
