Ian Skinner wrote: > basically, I want something to monitor a database table, and remove rows > of data that have not been updated in more than 10 seconds. > > Just to put another idea on the flagpole. What DBMS are you using? Does it > have triggers? That just sounded like a perfect task for a database trigger > so the database can take care of itself.
Triggers require some kind of action, right? If I close my browser window, there are rows sitting in the database and no action being formed on them. I don't see how a trigger could help. i'm using MySQL but even if I was using Oracle or SQL Server, I'm not sure how triggers would help. rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232589 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
