What about adding a "last_changed" column to your table. The initial value would be the date the record was entered. On edits to that record, this value would be edited (changed) to reflect the date those edits took place.
Then, finding records that didn't change in the last seven days is a matter of doing a "select" where "last_changed" < "today's date minus 7 days". HTH. >Anyone care to chime in on this? I've posted a thread which hasn't gotten >many responses yet and I'm wondering if any of you SQL wizards have input. > >http://www.sitepoint.com/forums/showthread.php?t=389438 > ><!----------------//------ >andy matthews >web developer >certified advanced coldfusion programmer >ICGLink, Inc. >[EMAIL PROTECTED] >615.370.1530 x737 >--------------//---------> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:242916 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
