quote:

---

Hmm...

I'm not sure what it could be right now. The only modification to the SQL string is the order by part of the SQL statement. From what you described about huwr's mod, it would be best to have that appear first in the order by, followed by the order by field from this mod. I'll have to look into huwr's mod, it sounds like something I'd be interested in anyways.

Something else to check - are all the field names (that are at the top within the variables section) available in your SQL string? Probably.

Select Case strtopicsortord
	Case "asc"
		strSortOrd = " ASC"
	Case Else
		strSortOrd = " DESC"
End Select

Select Case strtopicsortfld
	Case "topic"
		strSortCol = "T_SUBJECT" & strSortOrd
	Case "author"
		strSortCol = "T_AUTHOR" & strSortOrd
	Case "replies"
		strSortCol = "T_REPLIES" & strSortOrd
	Case "views"
		strSortCol = "T_VIEW_COUNT" & strSortOrd
	Case "lastpost"
		strSortCol = "T_LAST_POST" & strSortOrd
	Case Else
		strSortCol = "T_LAST_POST" & strSortOrd
End Select

What was the error message? Could you post a copy here?


"Do not go where the path may lead, go instead where there is no path and leave a trail."
-Ralph Waldo Emerson

---

quote:

---

since the server end (ReadyHosting)

---

Hey, I'm just one virtual directory down from you.

(I'm hosted on readyhosting too.)

At some point and probably the fastest way for me to attempt to help, if you could zip up your forum.asp file and make it accessable, I could take probably take a look at it. Also, do you have a url for the addinplace mod?

Thanks,
Dave


"Do not go where the path may lead, go instead where there is no path and leave a trail."
-Ralph Waldo Emerson

quote:

---

quote:

---

since the server end (ReadyHosting)

---

Hey, I'm just one virtual directory down from you.

(I'm hosted on readyhosting too.)

At some point and probably the fastest way for me to attempt to help, if you could zip up your forum.asp file and make it accessable, I could take probably take a look at it. Also, do you have a url for the addinplace mod?

Thanks,
Dave


"Do not go where the path may lead, go instead where there is no path and leave a trail."
-Ralph Waldo Emerson

---

ccc... now you know how gay is Readyhosting....
Huwr's AddinPlace is here
addinplace

It's not neccessary for me to zip it, cause I haved translate 90% to Chinese. But I think you can tell the difference from those two temp forums. But in case if you really want a copy, I don't mind zip it to you.



Edited by - lcs78816 on 25 May 2001 23:09:45

ADODB.Recordset error '800a0bb9' 

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. 

/forum/forum.asp, line 241 

	set rs = Server.CreateObject("ADODB.Recordset")
	rs.cachesize=20

Line 241=>	rs.open  strSql, my_Conn, 3
	if not (rs.EOF or rs.BOF) then
		rs.movefirst
		rs.pagesize = strPageSize
		maxpages = cint(rs.pagecount)
		rs.absolutepage = mypage
        inttotaltopics = rs.Recordcount
	end if
	
end if

quote:

---

ADODB.Recordset error '800a0bb9' 

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another. 

/forum/forum.asp, line 241 

---

quote:

---

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

?

---

quote:

---

quote:

---

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

?

---

I received this error message when I was setting up a new test forum with both addinplace and topic paging, but the reason was because I didn't have the TOPICS.T_INPLACE field (for the addinplace mod) in the database. But you would have received this error prior to installing the paging mod if that was the case. So I guess I'm still clueless why anyone would get that error.


"Do not go where the path may lead, go instead where there is no path and leave a trail."
-Ralph Waldo Emerson

---

I think there's a setup file in the addinplace mod.....
Which alter Topic table.....I think, cause I am not a programmer