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

[Venkat Rao Tammineni]

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:thomas.bonfort at gmail.com] 
Sent: Monday, December 15, 2008 11:57 AM
To: Venkat Rao Tammineni
Cc: mapserver-users at 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=xxxx

--
thomas

On Mon, Dec 15, 2008 at 06:32, Venkat Rao Tammineni
<vtammineni at roulacglobal.com> 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
> mapserver-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapserver-users
>
>