|
ajslentz
Starting Member
United States
7 Posts |
 Posted - 12 January 2008 : 16:18:33
|
Hi - I've just installed the Poll Mod 2.0 and am getting an error on post.asp. The error is:
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/post.asp, line 200
Line 200 reads: Forum_Polls = rsStatus("F_POLLS")
The select query I added reads:
'## Forum_SQL - Find out if the Category, Forum or Topic is Locked or Un-Locked and if it Exists
'################################# Poll Mod ##################################
'Added F.F_POLLS and T.T_POLLSTATUS to following SELECT statement.
strSql = "SELECT C.CAT_ID, C.CAT_NAME, C.CAT_STATUS, C.CAT_SUBSCRIPTION, " &_
"F.FORUM_ID, F.F_POLLS, F.F_STATUS, F.F_TYPE, F.F_SUBJECT, F.F_SUBSCRIPTION, "&_
"T.T_POLLSTATUS, T.T_STATUS, T.T_SUBJECT " &_
" FROM " & strTablePrefix & "CATEGORY C, " &_
strTablePrefix & "FORUM F, " &_
strActivePrefix & "TOPICS T" &_
" WHERE C.CAT_ID = T.CAT_ID " &_
" AND F.FORUM_ID = T.FORUM_ID " &_
" AND T.TOPIC_ID = " & strRqTopicID & ""
'############################################################
Any ideas??? I'm stuck on this one... |
|
Topic Locked
