| Author |
 Topic  |
|
|
blues
Starting Member
26 Posts |
 Posted - 30 May 2003 : 07:01:28
|
hi all
i have this problem in content.asp
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.
/forum/content.asp, line 125
my code is that's near the line 125
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText
if Not rs.EOF then
arrTopicData = rs.GetRows(TopicCount,1)
iTopicCount = UBound(arrTopicData, 2)
else
iTopicCount = ""
end if
before i 've thats code
select case DisplayOrder ' Change ASC to DESC if preferred...
case 0 ' By Last Posted Date
strSql = strSql & " ORDER BY T.T_LAST_POST DESC "
case 1 ' By Topics Order field
strSql = strSql & " AND T.T_ORDER > 0 " ' Required because NULLs and ZEROs come before 1
strSql = strSql & " ORDER BY T.T_ORDER ASC "
case 2 ' By most View Counts
strSql = strSql & " ORDER BY T.T_VIEW_COUNT DESC "
case 3 ' By most Replies
strSql = strSql & " ORDER BY T.T_REPLIES DESC "
case 4 ' By msgIcons value
strSql = strSql & " ORDER BY T.T_MSGICON ASC "
case 5 ' By author
strSql = strSql & " ORDER BY T.T_AUTHOR ASC "
case 6 ' By original post Date
strSql = strSql & " ORDER BY T.T_DATE ASC "
case 7 ' By Forum ID
strSql = strSql & " ORDER BY T.FORUM_ID DESC "
case 8 ' By Cat ID
strSql = strSql & " ORDER BY T.CAT_ID DESC "
case else ' Use the "default" - By Last Posted Date - DESC
strSql = strSql & " ORDER BY T.T_LAST_POST DESC "
end select
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize = 20
rs.open strSql, my_Conn, 3, adLockReadOnly, adCmdText
if Not rs.EOF then
arrTopicData = rs.GetRows(TopicCount,1)
iTopicCount = UBound(arrTopicData, 2)
else
iTopicCount = ""
end if |
Edited by - Davio on 30 May 2003 12:41:31 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
|
|
blues
Starting Member
26 Posts |
Posted - 30 May 2003 : 10:21:32
|
| yes it's a mod!!!! |
 |
|
|
Nikkol
Forum Moderator
USA
6907 Posts |
Posted - 30 May 2003 : 10:36:51
|
Can a Moderator please move this to the MOD Implementation forum please.
blues ... saying that it is a mod is all fine and good, but I know I can't help much unless I know WHAT mod it is. |
Nikkol ~ Help Us Help You | ReadMe | 3.4.03 fixes | security fixes ~ |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 30 May 2003 : 12:38:08
|
I don't see any bookmarks being used in the code you posted. Post a link to a txt version of your content.asp file.
Are you sure you are using a MySQL database? |
Support Snitz Forums
|
Edited by - Davio on 30 May 2003 12:40:37 |
|
|
|
blues
Starting Member
26 Posts |
Posted - 02 June 2003 : 07:00:23
|
sorry for all my error , my friends!!!
ok the mod is content display mod,
yes i'm sure i'm using a Mysql database
this is the link with te txt files
thanks http://www.assitecforum.com/forum2/content.txt |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 02 June 2003 : 11:39:14
|
Comment out line 124:'rs.cachesize = 20 Cachesize is not supported by mysql. |
Support Snitz Forums
|
|
|
|
blues
Starting Member
26 Posts |
Posted - 03 June 2003 : 10:44:03
|
how i can solve this problem????
thanks for your answer |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 03 June 2003 : 12:54:05
|
| I just showed you how to solve it. Comment out line 124, by placing a single quote (I highlighted it in red so you can see it in my last post) in front of the code. |
Support Snitz Forums
|
|
|
|
blues
Starting Member
26 Posts |
Posted - 04 June 2003 : 10:05:10
|
| ops i'm a stupid!!!! thanks my friend |
|
|
|
blues
Starting Member
26 Posts |
Posted - 04 June 2003 : 10:30:00
|
i've the same error in this line
arrTopicData = rs.GetRows(TopicCount,1) |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 04 June 2003 : 13:29:40
|
| Are you surE? Post all of the error message you are getting. |
Support Snitz Forums
|
|
|
| |
Topic |
|
Topic Locked
