I think that is a viable solution, set the "last_changed" column to be auto-populated with Now() or Dtae() Whatever is it, sorry don't remember that one right now.
-----Original Message----- From: Irvin Gomez [mailto:[EMAIL PROTECTED] Sent: Thursday, June 08, 2006 9:50 AM To: CF-Talk Subject: Re: Find which records have changed over a 7 day period. 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:242919 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
