> 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:263715 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
