|
prankmonkey
Starting Member
7 Posts |
 Posted - 12 May 2002 : 16:57:16
|
Hi Im receiving this error:
Error Type:
ADODB.Recordset (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/crzychinaman/forum/inc_functions.asp, line 1790
Line 1790 on inc_functions.asp is:
rsGetMemberID.open strSql, my_Conn
code around it is :
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
Please help me.....
Edited by - prankmonkey on 12 May 2002 17:00:24
Edited by - prankmonkey on 12 May 2002 17:25:00 |
|
Topic Locked
