Ok, I've come up with a "better" way than my last idea... Once again, just wondering if anyone sees any holes in my thinking or flat out a better way of doing it.
Each users record gets a LastVisit column. Each time they login, the date from that field gets set in the session scope with the rest of their login info. Any thread with a post newer than that date is marked with a "New Post" icon initially. As the user moves around and views threads, the date of the latest post in threads marked as "New Posts" gets stored in the database MemberID, ThreadID, LatestPostDate (overwrites existing records with the same ThreadID) Now as long as the thread has a LastPostDate newer than session.var.LastVisit AND newer than the latest date entered in the "Viewed" table for that ThreadID session.var.memberID it's marked with a "New Post" icon. Now each time the user logs in, his/her "Viewed" records can be purged and started over. It's not 100% accurate since "New Posts" you don�t look at when logged in will not be marked as "New Posts" the next time you login but I'd be happy as a user with this method. Sorry the posts are so long and somewhat cryptic, just thinking out loud. -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.6.9 - Release Date: 1/6/2005 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:189735 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
