Classic ASP Discussion - A quick bit of help please...

Print Page | Close Window

A quick bit of help please...

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=2160
Printed Date: 29 March 2026 at 12:01pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: A quick bit of help please...

Posted By: slave
Subject: A quick bit of help please...
Date Posted: 26 April 2003 at 8:51am

Hi, I'm setting up a website for a band and I have all the past and upcoming concerts in a simple Access table (it's just 'gigID', 'gigDate' and 'gigLocation').

What I'd like is to be able to show the next gig on the homepage so it would simply get the current date and then look through the db to see when the next one is and display it.

I'm a bit new to this and I'm not sure how to go about it, could someone help me with this?

Thanks.

Replies:

Posted By: michael
Date Posted: 26 April 2003 at 9:18am

Select Top 1 (*) from table where gigdate > now()

-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker