| Author |
 Topic  |
|
|
aspwiz
Junior Member
250 Posts |
 Posted - 05 July 2001 : 08:25:26
|
Hi.... I have the latest versions of the forum, and the fileupload mod, along with the Slemmies Poll mod.
I can edit replies fine, but when it comes down to editing the main topic, I get the following error....
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/post.asp, line 417
Any ideas whats up? I followed the readme's to the letter!!!
Edited by - aspwiz on 05 July 2001 08:25:56 |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 05 July 2001 : 11:32:30
|
You're missing some sql code in your post.asp page.
Look through the post.asp file in the zip with the post.asp file in your forum and make sure you have all the code modifications added.
You can start looking around line 417 in the post.asp in the zip to see what code you are missing.
- David |
 |
|
|
pfilias
New Member
69 Posts |
Posted - 17 July 2001 : 13:45:59
|
The reason this error occurred for me is because I missed a line of modification. I'll paste and bold the line below: lines 406-425 in my code.
'## Forum_SQL
' ############## Poll Mod - 1 line #################
strSql = "SELECT " & strTablePrefix & "TOPICS.CAT_ID, " & strTablePrefix & "TOPICS.FORUM_ID, " & strTablePrefix & "TOPICS.TOPIC_ID, " & strTablePrefix & "TOPICS.T_SUBJECT, " & strTablePrefix & "TOPICS.T_AUTHOR, " & strTablePrefix & "TOPICS.T_MAIL, " & strTablePrefix & "TOPICS.answer1, " & strTablePrefix & "TOPICS.answer2, " & strTablePrefix & "TOPICS.answer3, " & strTablePrefix & "TOPICS.answer4, " & strTablePrefix & "TOPICS.answer5, " & strTablePrefix & "TOPICS.answer6, " & strTablePrefix & "TOPICS.answer7, " & strTablePrefix & "TOPICS.answer8, " & strTablePrefix & "TOPICS.T_MESSAGE "
strSql = strSql & " FROM " & strTablePrefix & "TOPICS "
strSql = strSql & " WHERE " & strTablePrefix & "TOPICS.TOPIC_ID = " & Request.QueryString("TOPIC_ID")
set rs = my_Conn.Execute (strSql)
TxtSub = rs("T_SUBJECT")
strAuthor = rs("T_AUTHOR")
' ############# Poll Mod ####################
txtSub1 = trim(rs("answer1"))
txtSub2 = trim(rs("answer2"))
txtSub3 = trim(rs("answer3"))
txtSub4 = trim(rs("answer4"))
txtSub5 = trim(rs("answer5"))
txtSub6 = trim(rs("answer6"))
txtSub7 = trim(rs("answer7"))
txtSub8 = trim(rs("answer8"))
' ######################################### I was missing the 1-line mod way above.
Edited by - pfilias on 17 July 2001 14:06:00
Edited by - pfilias on 17 July 2001 14:06:52 |
|
|
| |
Topic |
|
|
|
Topic Locked
