last modified

Results 1 to 2 of 2

Thread: last modified

  1. #1
    Join Date
    Dec 1969

    Default last modified

    If I update the database the same should reflect on the asp page and the date of last update should be displayed on the page.

  2. #2
    Join Date
    Dec 1969

    Default RE: last modified

    If you want to display the latest update of a table on you ASP (page) then <BR><BR>Clearly, you will need a column in the table that you have updated that will give the date/time of the update. Then you can show the highest value for this field.....<BR><BR>mySQL="SELECT max(dtmLastUpdated) as LastUpdate from myUpdatedTable"<BR>set myRS= Server.CreatObject("ADODB.Recordset")<BR> mySQL, strMyConnect<BR><BR>Response.Write ("&#060;P&#062; Last Database Update : " & myRS("LastUpdate))<BR>myRS.Close<BR>set myRS=nothing<BR><BR><BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts