quote:

---

Originally posted by Hamlin

Try adding a ,

366 "T.T_MSGICON ," & _

---

Microsoft JET Database Engine error '80040e14' 

The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect. 

/forum/active.asp, line 306 

'## Forum_SQL - Get all active topics from last visit
strSql = "SELECT F.FORUM_ID, " & _
         "F.F_SUBJECT, " & _
	 "F.F_SUBSCRIPTION, " & _
	 "F.F_STATUS, " & _
         "C.CAT_ID, " & _
	 "C.CAT_NAME, " & _
	 "C.CAT_SUBSCRIPTION, " & _
	 "C.CAT_STATUS, " & _
	 "T.T_STATUS, " & _
	 "T.T_VIEW_COUNT, " & _
	 "T.TOPIC_ID, " & _
	 "T.T_SUBJECT, " & _
	 "T.T_AUTHOR, " & _
	 "T.T_REPLIES, " & _
	 "T.T_UREPLIES, " & _
	 "M.M_NAME, " & _
	 "T.T_LAST_POST_AUTHOR, " & _
	 "T.T_LAST_POST, " & _
	 "T.T_LAST_POST_REPLY_ID, " & _
	 "MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, " & _
	 "T.T_MSGICON " & _
	 "FROM " & strMemberTablePrefix & "MEMBERS M, " & _
	 strTablePrefix & "FORUM F, " & _
	 strTablePrefix & "TOPICS T, " & _
	 strTablePrefix & "CATEGORY C, " & _
	 strMemberTablePrefix & "MEMBERS MEMBERS_1 " & _
	 "WHERE T.T_LAST_POST_AUTHOR = MEMBERS_1.MEMBER_ID "

265	 "MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, " & _
366	"T.T_MSGICON " & _
367	 "F.F_PRIVATEFORUMS, " & _
268	 "F.F_PASSWORD_NEW " & _
269	 "FROM " & strMemberTablePrefix & "MEMBERS M, " & _

441	fT_LAST_POST_REPLY_ID = 18
442	fLAST_POST_AUTHOR_NAME = 19
443	fT_MSGICON = 20

	fT_LAST_POST_REPLY_ID = 18
	fLAST_POST_AUTHOR_NAME = 19
	fF_PRIVATEFORUMS = 20
	fF_PASSWORD_NEW = 21

	fF_PRIVATEFORUMS = 20
	fF_PASSWORD_NEW = 21

	 "F.F_PASSWORD_NEW " & _
	 "FROM " & strMemberTablePrefix & "MEMBERS M, " & _

Replace it with this code:

	 "F.F_PASSWORD_NEW " & _
	 "T.T_MSGICON " & _
	 "FROM " & strMemberTablePrefix & "MEMBERS M, " & _

	fT_LAST_POST_REPLY_ID = 18
	fLAST_POST_AUTHOR_NAME = 19
	fF_PRIVATEFORUMS = 20
	fF_PASSWORD_NEW = 21
	fT_MSGICON = 22