Forums: [SOLVED] date time stamp - Forums

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked

[SOLVED] date time stamp Display date/time page was updated Rate Topic: -----

#1 User is offline   mwill9872 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 23-March 03

Post icon  Posted 04 April 2003 - 02:02 AM

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...... :blink:
0

#2 User is offline   admin 

  • Administrator
  • PipPipPip
  • Group: Admin
  • Posts: 15495
  • Joined: 03-February 03

Posted 06 April 2003 - 06:33 PM

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:

Quote

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
Best regards,
Sergey Kornilov
0

#3 User is offline   mwill9872 

  • Newbie
  • Pip
  • Group: Members
  • Posts: 9
  • Joined: 23-March 03

Posted 10 April 2003 - 11:54 PM

worked great! thanks mike
0

#4 User is offline   osluk 

  • Advanced Member
  • PipPipPip
  • Group: Members
  • Posts: 151
  • Joined: 24-May 04

Posted 25 May 2004 - 08:19 PM

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

Thanks Chris
0

Page 1 of 1
  • You cannot start a new topic
  • This topic is locked