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
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=
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
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