| Author |
 Topic  |
|
Tyler M.
New Member
USA
82 Posts |
 Posted - 29 November 2002 : 22:03:29
|
quote:
SELECT TOP 10 R_AUTHOR, MEMBER_ID, M_NAME, M_DATE, M_POSTS, M_TITLE, M_LEVEL, M_LASTPOSTDATE, M_AVATAR_URL, COUNT(R_AUTHOR) AS T_POSTS FROM (SELECT R_AUTHOR, MEMBER_ID, M_NAME, M_DATE, M_POSTS, M_TITLE, M_LEVEL, M_LASTPOSTDATE, M_AVATAR_URL, R_DATE FROM (FORUM_MEMBERS INNER JOIN FORUM_REPLY ON FORUM_MEMBERS.MEMBER_ID=FORUM_REPLY.R_AUTHOR) WHERE R_DATE > '20021030200755' AND M_NAME <> '' UNION SELECT T_AUTHOR, MEMBER_ID, M_NAME, M_DATE, M_POSTS, M_TITLE, M_LEVEL, M_LASTPOSTDATE, M_AVATAR_URL, T_DATE FROM (FORUM_MEMBERS INNER JOIN FORUM_TOPICS ON FORUM_MEMBERS.MEMBER_ID=FORUM_TOPICS.T_AUTHOR) WHERE T_DATE > '20021030200755' AND M_NAME <> '') As MyView GROUP BY R_AUTHOR, MEMBER_ID, M_NAME, M_DATE, M_POSTS, M_TITLE, M_LEVEL, M_LASTPOSTDATE, M_AVATAR_URL ORDER BY Count(R_AUTHOR) DESC, MEMBER_ID ASC;
Here is what it reads... |
Edited by - Tyler M. on 29 November 2002 22:03:51 |
 |
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 29 November 2002 : 23:30:29
|
hi~ Tayler,
the SQL string look is ok.... 
i really do'nt understand what that error message meaning...
Microsoft JET Database Engine error '80004005'
Could not use ''; file already in use.
someone help me, please. thanks ! 
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 30 November 2002 : 01:03:24
|
| good job, I even switched over to your version :) the one I was using was very, very popular at my site and I think they'll enjoy this layout better. thanks. |
 |
|
|
|
Tyler M.
New Member
USA
82 Posts |
Posted - 30 November 2002 : 02:06:10
|
Thank you for finding the links about permissions. It required the folder to have R/W/M access. I always only gave the actual MDB R/W permission, and nothing else...
Anyway, that solved the problem. Thanks for figuring out something I should have done myself. You indeed are a value to the snitz community.
-Tyler
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 30 November 2002 : 02:10:40
|
I had some problems with numbers duplicating in the ranking. It would show the following:
1
2
3
4
5
6
7
8
9
10
10
12
13
14
15
here is the code I had to edit to fix this problem
if Int(Members_MemberTopPosts) = currPosts then
showOrder = showOrder+1
else
currPosts = Int(Members_MemberTopPosts)
showOrder = j
end if |
|
|
|
|
DoraMoon
Average Member
Taiwan
661 Posts |
Posted - 30 November 2002 : 07:45:53
|
thanks! dayve, 
but the ranking ShowOrder just designed for this..
if users have the same posts count, then they got the same rank number.
i do'nt know, maybe it just our convention in my country...
the rank ..9,10,10,12... seem not so unusual for me. if they really got the same posts.
anyway, if someone do'nt like this strange rank method, you can apply above dayve's fixed code.
or remove the lines related to ShowOrder and change line.376
Response.Write "<font style=""font-size:15pt; font-family:Cataneo BT; color:" & strHiLiteFontColor & """><b>" & showOrder & "</b></font>" & vbNewLine
to this..
Response.Write "<font style=""font-size:15pt; font-family:Cataneo BT; color:" & strHiLiteFontColor & """><b>" & rec & "</b></font>" & vbNewLine
|
|
|
|
dayve
Forum Moderator
USA
5820 Posts |
Posted - 30 November 2002 : 12:20:40
|
ahhhh, that makes more sense now... didn't notice that the people holding the 10th position had the same number of posts.... you're a clever one !!  |
|
|
|
|
Topic |
|
|
|
Topic Locked
