Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gDeveloper88
Starting Member
3 Posts |
 Posted - 2007-06-01 : 11:19:32
|
| Hi, thank you for looking at this question, I have an application that has normal users that update data and admin users. Every 3 months (Quarterly), the admin checks to see which users have not updated their records. In the admin interface, there would be buttons like "Quarter1", "Quarter2", "Quarter3", "Quarter4" for given year (now it would be 2007). I am using coldfusion MX7 and sql server 2000.Do you have an idea what is the best (possibly simple) approach to this, given the fact that I'm not that experienced in sql coding or coldfusion ?Any help is very appreciated, thanks in advance !C |
|
|
blindman
Master Smack Fu Yak Hacker
2365 Posts |
Posted - 2007-06-01 : 12:04:36
|
| You need a datetime column on your table with a default set to getdate(), and then an ON UPDATE trigger on the table to reset the value when changes are made.e4 d5 xd5 Nf6 |
 |
|
|
gDeveloper88
Starting Member
3 Posts |
Posted - 2007-06-01 : 12:40:26
|
| Hi blindman, thank you so much for your reply, I'm not too experienced with SQL Server20001. How do I set default of column to getdate()? I'm trying to do that on SQL Ent. Manager design table console?2. For your trigger, I would right-click on table and go to 'Manage Triggers' and put code there?Thanks so much,C |
|
|
|
|
|
|
|
|
Hi, what is the best way to record data on users e