Tell me if this goes in mod implementation or not. I'm working on a mod, and I'm trying to get the topic ID after it is added to the database. In the code for post_info.asp I've found the insert statement, and right after that there's a select statement on line 851 that starts with this:
strSql = "SELECT Max(TOPIC_ID) as NewTopicID "
Is it safe to use NewTopicID as that topics ID? What if someone is posting at the same time?
Normally I would just grab try to grab the id after the new topic is posted, but I'm not sure how to do that without using a recordset Object. I would normally grab it like this:
That can work, but it can also fail. Just imagine that at the same moment you posted your topic, someone else did too (it can happen, it has happened here having posts made at the same exact second). To avoid failure I would suggest that you add an extra condition:
strSql = "SELECT Max(TOPIC_ID) as NewTopicID WHERE T_AUTHOR=" & MemberID
This will get the highest topic id for your logged in member. It diminishes the chances for failure just a little bit more.
I'm working on converting this stored procedure here http://www.sqlteam.com/item.asp?ItemID=1353 so I can have a threaded view mod for our forum. Babygate hasn't added an updated version for 3.4
Topic Locked
Posted - 30 August 2002 : 14:56:12
.