I dont know if this is a bug but i think its something that should be fixed. This is the way the function looks...
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 think this should have a little error checking like so..
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.eof or rsGetMemberID.bof then
Call ClearCookies()
getMemberID = "0"
else
getMemberID = rsGetMemberID("MEMBER_ID")
end if
rsGetMemberID.close
set rsGetMemberID = nothing
end function
The reason I am saying this is because a forum I am working on my member name got deleted and now i can not access the forums because im getting this error message..
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/inc_functions.asp, line 841
what do you guys think?
Brad
Web Hosting with SQL Server @ $24.95 per month
Snitz Mod Archive
Edited by - redbrad0 on 08 January 2002 00:46:30
Edited by - redbrad0 on 08 January 2002 00:49:15
Topic Locked
Posted - 08 January 2002 : 00:34:21
