Reply to Re: Quick SQL Select Statement ?

Your name:

Reply:


Posted by t8ntboy on 03/20/07 20:42

On Mar 20, 4:33 pm, Ed Murphy <emurph...@socal.rr.com> wrote:
> t8ntboy wrote:
> > I am using SQL Server Express and ASP.
>
> > I have a table that contains news articles, headlines, start and end
> > dates. I am trying to create a recordset that shows all of the
> > articles that are greater than or equal to the start date and less
> > than or equal to the end date. For some reason I cannot get it to
> > function properly using a statement similar to StartDate >= Now() AND
> > EndDate <= Now(). SQL doesnt like the Now() piece of the statement.
> > Anyone have an idea how I can get this to work? I have also tried
> > CURDATE() but to no avail.
>
> StartDate <= GetDate() and EndDate >= GetDate()

Ed:

Many thanks!!!

[Back to original message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация