Hi,
Im currently writing an ASP page to select a record from a database based on the time stamp created when added. At present this has to be done manually - the user currently selects the hour they want the random record from (have randomisation sorted) and submits, system takes random record from that hour and copies to a new table.
Basically im trying to find out if there is anyway to do this automatically every hour without the user having to manually select the winner (sorry, its for a quiz, winners selected every hour).
Im using an Access Database and running off a Virtual Server running Server 2003.
Any help always appreciated.
ShotoCon
Im currently writing an ASP page to select a record from a database based on the time stamp created when added. At present this has to be done manually - the user currently selects the hour they want the random record from (have randomisation sorted) and submits, system takes random record from that hour and copies to a new table.
Basically im trying to find out if there is anyway to do this automatically every hour without the user having to manually select the winner (sorry, its for a quiz, winners selected every hour).
Im using an Access Database and running off a Virtual Server running Server 2003.
Any help always appreciated.
ShotoCon
