|
kimkr
Starting Member
Denmark
36 Posts |
 Posted - 13 February 2002 : 17:33:32
|
I use different prefixes for the strTablePrefix and strMemberTablePrefix, and sofar I have found two errors (I couldn't find anyone how has reportet it yet)
I found it in 4bpatch002:
In default.asp near line 200
strTablePrefix & "FORUM.F_A_COUNT, " &_
strMemberTablePrefix & "FORUM.F_SUBSCRIPTION, " &_
strMemberTablePrefix & "MEMBERS.MEMBER_ID, " &_
strMemberTablePrefix & "MEMBERS.M_NAME " &_
sould be:
strTablePrefix & "FORUM.F_A_COUNT, " &_
strTablePrefix & "FORUM.F_SUBSCRIPTION, " &_
strMemberTablePrefix & "MEMBERS.MEMBER_ID, " &_
strMemberTablePrefix & "MEMBERS.M_NAME " &_
and in file inc_functions.asp near line 1097
function chkForumModerator(fForum_ID, fMember_Name)
'## Forum_SQL
strSql = "SELECT mo.FORUM_ID "
strSql = strSql & " FROM " & strTablePrefix & "MODERATOR mo, " & strTablePrefix & "MEMBERS me "
strSql = strSql & " WHERE mo.FORUM_ID = " & fForum_ID & " "
strSql = strSql & " AND mo.MEMBER_ID = me.MEMBER_ID "
shoul be:
function chkForumModerator(fForum_ID, fMember_Name)
'## Forum_SQL
strSql = "SELECT mo.FORUM_ID "
strSql = strSql & " FROM " & strTablePrefix & "MODERATOR mo, " & strMemberTablePrefix & "MEMBERS me "
strSql = strSql & " WHERE mo.FORUM_ID = " & fForum_ID & " "
strSql = strSql & " AND mo.MEMBER_ID = me.MEMBER_ID "
Edited by - kimkr on 13 February 2002 17:39:12
[moved by bozden on 30 September 2002]
< |
Edited by - Deleted on 30 September 2002 18:19:39 |
|
Topic Locked
