MySQL and MS-SQL have different syntax and function names for dealing
with dates.
On Jun 22, 2004, at 12:35 PM, Roger Withnell wrote:
I use ASP/MS-SQL, but you first need to use SQL to select the correct
records, something like:
SELECT * from TABLE WHERE StartDate <= GetDate() AND EndDate >=
GetDate() -
(GetDate() is the current date)
And then use a "While not EOF" loop to step through the records,
writing
them to the page.
Lucas Holt
email@hidden
________________________________________________________
FoolishGames.com (Jewel Fan Site)
JustJournal.com (Free blogging)
_______________________________________________
web-development mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/web-development
Do not post admin requests to the list. They will be ignored.
