I believe this is the proper place to post this, if there is a better place, please let me know.
I noticed in the inc_funcions.asp
function getMemberID(fUser_Name)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(fUser_Name, "SQLString") & "'"
Set rsGetMemberID = Server.CreateObject("ADODB.Recordset")
rsGetMemberID.open strSql, my_Conn
getMemberID = rsGetMemberID("MEMBER_ID")
rsGetMemberID.close
set rsGetMemberID = nothing
end function
I noticed that there is no error checking for EOF or BOF.
Although that is fine, here is something that should be considered:
function getMemberID(fUser_Name)
'## Forum_SQL
strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(fUser_Name, "SQLString") & "'"
Set rsGetMemberID = Server.CreateObject("ADODB.Recordset")
rsGetMemberID.open strSql, my_Conn
if rsGetMemberID.BOF or rsGetMemberID.EOF then
strLoginStatus = 0
else
getMemberID = rsGetMemberID("MEMBER_ID")
rsGetMemberID.close
end if
set rsGetMemberID = nothing
end function
That may be a little more user friendly with some of the mod updates.
(Web Zone Complete)
Programming and graphic resource center
Topic Locked
Posted - 04 May 2002 : 10:59:35
