This topic is locked
[SOLVED]

 date time stamp

4/3/2003 9:02:29 PM
ASPRunnerPro General questions
M
mwill9872 author

How would I display the date and time the web server's database was last updated using runner.....
My setup is.........
I have an access database running outside the webserver which does all the work........ this database runs a maketable query 2 times per day to the database on the webserver that the .asp is pulling the data from.
it also creates a table called "ztime" on the webserver...... <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=43&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' />

admin 4/6/2003

Hi,
I'm sure what exactly you tring to do but hopefully this can help.

Just put this code where you like to display timestamp:

Set rs = server.CreateObject ("ADODB.Recordset")

set dbConnection = server.CreateObject ("ADODB.Connection")

dbConnection.ConnectionString = strConnection

dbConnection.Open

strSQL = "select lastupdated from ztime"

rs.open strSQL, dbConnection

Response.Write rs("LastUpdated")

rs.Close

dbConnection.Close

set rs = nothing

set dbConnection = nothing


Sergey Kornilov

M
mwill9872 author 4/10/2003

worked great! thanks mike

O
osluk 5/25/2004

Where did this code go? Is it the same for the current versions .net etc.
Thanks Chris