Hi,
I want to show the last updated date on a site. Rather than do this
manually, is there a way I can get this programatically for a table in
mySQL?
Also, is it possible with an MSACCESS database? Part of the site runs on an
old access database, so rather than update it all (they don't want
Resending this. I had a major mailserver problem this am and lost a few
mails, so just incase I missed any replies!
-Original Message-
From: Will Swain [mailto:[EMAIL PROTECTED]
Sent: 12 December 2006 09:55
To: CF-Talk
Subject: last updated date from MySql
I want to show the last updated date on a site. Rather than do this
manually, is there a way I can get this programatically for a table in
mySQL?
I guess I'm confused. Do you want to show the last time a DB table
was updated, or just show the latest record using a time stamp field?
If it's
PROTECTED]
Sent: 12 December 2006 14:43
To: CF-Talk
Subject: Re: last updated date from MySql database
I want to show the last updated date on a site. Rather than do this
manually, is there a way I can get this programatically for a table in
mySQL?
I guess I'm confused. Do you want to show
I just want to check the last time a table was updated and display that time
on the homepage. I know I can write some code that marks the time of an
update or insert into the database and use that, but I noticed that mySQL
tables have an update time on them, and wondered if I can shortcut and
Thanks Jacob. Thought it might be something standard that I was unaware of.
I'll go read the mySQL docs.
Will
-Original Message-
From: Jacob Munson [mailto:[EMAIL PROTECTED]
Sent: 12 December 2006 17:49
To: CF-Talk
Subject: Re: last updated date from MySql database
I
6 matches
Mail list logo