Gurb
Starting Member
8 Posts |
Posted - 26 April 2004 : 11:00:06
|
Hi, i noticed a little bug in the code
If you try to post a new topic from an Archive , everything is fine except the update of the last topic The query is (line 851) strSql = "SELECT Max(TOPIC_ID) as NewTopicID " strSql = strSql & " FROM " & <b>strActivePrefix</b> & "TOPICS " strSql = strSql & " WHERE FORUM_ID = " & Forum_ID strSql = strSql & " and T_AUTHOR = " & rs("MEMBER_ID") set rs9 = my_Conn.Execute (strSql)
And since you came from Archiveview the Archiveview parameter is set to true. So the code updates the table with the last Archived topic_id not with the last posted Topic_id
Perhaps <b>strActivePrefix</b> should be <b>strTablePrefix</b> Ciao |
|