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 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.
Oh, I see. I didn't know mySQL did that. I don't know how you'd access
that. How are you seeing this last updated date, from the MySQL Admin? You
could google around, there might be something with "show tables" you could
do...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:263826
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
