Is there a way to read the timestamp of the last time a record or table was written to, aside from creating a field and dumping Now() to it each time code writes to it?
I have a db that gets imports at intervals, and my ASP pages simply provide web reporting off that table. I'd like to identify on the report how old the data is. I don't want to use FileSystemObject to read the timestamp of the db itself. Is there another way?
* The optimist says the cup is half full. The pessimist says it's half empty. But the engineer knows the truth - the cup's design is incorrectly sized.
If you are using MSSQL, you could create a TRIGGER that dumped the getdate() value into somewhere that you could access, possibly, even, a text file that you could use as an INCLUDE in your ASP page. I don't know if writing to a file is possible from a stored procedure, but it might be worth investigating.
--Jördan It's a wasted day if you don't spend at least part of it flying upside down.
Topic Locked
Posted - 20 August 2003 : 18:33:10
