| Author |
 Topic  |
|
|
godmode
Starting Member
USA
25 Posts |
 Posted - 04 July 2001 : 14:07:21
|
When i go to do a search on anything it comes back with this error.
ADODB.Recordset error '800a0cc1'
Item cannot be found in the collection corresponding to the requested name or ordinal.
/forum/Search.asp, line 216
it only shows the the 1st topic it found then gives this error. Any ideas?
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 July 2001 : 14:37:02
|
Can you post a link to your forums please.
Also a link to a txt version of your search.asp file would be helpful.
- David |
 |
|
|
godmode
Starting Member
USA
25 Posts |
Posted - 04 July 2001 : 14:38:46
|
quote:
Can you post a link to your forums please.
Also a link to a txt version of your search.asp file would be helpful.
- David
www.pmpaintball.com/forum
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
|
|
godmode
Starting Member
USA
25 Posts |
Posted - 04 July 2001 : 15:19:51
|
That didnt help. Its possible i added the code wrong so i will paste it here..
strSql = "SELECT " & strTablePrefix & "FORUM.FORUM_ID, " & strTablePrefix & "FORUM.F_SUBJECT, " & strTablePrefix & "FORUM.CAT_ID, " & strTablePrefix & "TOPICS.TOPIC_ID, " & strTablePrefix & "TOPICS.T_SUBJECT, " & strTablePrefix & "TOPICS.T_MAIL, " & strTablePrefix & "TOPICS.T_STATUS, " & strTablePrefix & "TOPICS.T_LAST_POST, " & strTablePrefix & "TOPICS.T_REPLIES, " & strTablePrefix & "TOPICS.T_VIEW_COUNT, " & strMemberTablePrefix & "MEMBERS.MEMBER_ID, " & strMemberTablePrefix & "MEMBERS.M_NAME "
strSql = strSql & " FROM ((" & strTablePrefix & "FORUM LEFT JOIN " & strTablePrefix & "TOPICS "
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 July 2001 : 23:58:20
|
did the error message changed or did you get the same error?
I also asked in my previous posts if you could post a link to a txt version of your search.asp file.
- David |
|
|
| |
Topic |
|
Topic Locked
