RE: [mapserver-users] How to get data based on Date in Postgresql/PostGIS

2008-12-15 Thread Venkat Rao Tammineni
NIQUE gid USING 'SRID=3000'" Thanks, Venkat. -Original Message- From: thomas bonfort [mailto:thomas.bonf...@gmail.com] Sent: Monday, December 15, 2008 11:57 AM To: Venkat Rao Tammineni Cc: mapserver-users@lists.osgeo.org Subject: Re: [mapserver-users] How to get data based on D

RE: [mapserver-users] How to get data based on Date in Postgresql/PostGIS

2008-12-15 Thread Venkat Rao Tammineni
mber 15, 2008 11:57 AM To: Venkat Rao Tammineni Cc: mapserver-users@lists.osgeo.org 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=

Re: [mapserver-users] How to get data based on Date in Postgresql/PostGIS

2008-12-14 Thread thomas bonfort
try DATA the_geom from (select id,the_geom from pointlayer where date='12/2/2008') as foo using unique id using srid= -- thomas On Mon, Dec 15, 2008 at 06:32, Venkat Rao Tammineni wrote: > Dear All, > > > > I want get data based on Date. When I run query select * from > PointLayer wher

[mapserver-users] How to get data based on Date in Postgresql/PostGIS

2008-12-14 Thread Venkat Rao Tammineni
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 dat