Hi Jacob,
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 just
use that data. There are a number of tables that can be updated, so I'd need
to check them all, compare the updated times and only show the most recent.
Does that make more sense?
Cheers
Will
-----Original Message-----
From: Jacob Munson [mailto:[EMAIL 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 the last time a DB table was
updated, or just show the latest record using a time stamp field?
If it's the former, you could use an 'on insert' trigger to keep track of
updates to the table, but it would be much easier if you just had a
date/time field in the table where you put in now() with each insert/update,
and then display that on your site.
--
My Sites:
http://www.techfeed.net/blog/
http://www.cfquickdocs.com/
http://cfformprotect.riaforge.org/
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263747
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
