ADODB.Recordset error '800a0bb9' 

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

/forum/inc_functions.asp, line 1981 
 

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 not rsGetMemberID.eof then
	getMemberID = rsGetMemberID("MEMBER_ID")
	else
	getMemberID = 0
	end if
	
	rsGetMemberID.close
	set rsGetMemberID = nothing
end function

function getNewMemberNumber()
	'## Forum_SQL
	strSql = "SELECT " & strMemberTablePrefix & "MEMBERS.MEMBER_ID "
	strSql = strSql & " FROM " & strMemberTablePrefix & "MEMBERS "
	strSql = strSql & " WHERE " & strDBNTSQLName & " = '" & ChkString(strDBNTUserName, "SQLString") & "'"

	Set rsGetMemberID = Server.CreateObject("ADODB.Recordset")
	rsGetMemberID.open strSql, my_Conn

	if rsGetMemberID.EOF or rsGetMemberID.BOF then
		getNewMemberNumber = -1
		rsGetMemberID.close
		set rsGetMemberID = nothing
		exit function
	end if

	getNewMemberNumber = rsGetMemberID("MEMBER_ID")
	rsGetMemberID.close
	set rsGetMemberID = nothing
end function

Crash's Site | Crash is from