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

[Venkat Rao Tammineni]

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