Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: MOD Implementation
 Events Mod installed - can't read replies in foru
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

eze311
Starting Member

9 Posts

Posted - 06 March 2002 :  10:29:36  Show Profile  Visit eze311's Homepage
I searched for this topic to no avail. I have vs.3.03.03 with a Access 2000 DB, and the active users mod installed. I installed the events mod and it works. I now cannot read the replies in my forum
http://www.yourcoast.com/forum
I get this error
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

line 1981 is rsGetMemberID.open strSql, my_Conn

Any help will be greatly appreciated!


mnew
Starting Member

United Kingdom
8 Posts

Posted - 03 April 2002 :  09:49:12  Show Profile  Visit mnew's Homepage
If it's any consolation, you are not alone : ((

Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts

Posted - 03 April 2002 :  13:26:23  Show Profile  Visit crash's Homepage
could you post the name of the function in which this code sits?

if the function's called "getMemberID(fUser_Name)" you could try this here:
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


if the one you refer to is called "getNewMemberNumber()" you could try this here:
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
Go to Top of Page

crash
Advanced Member

Netherlands
2064 Posts

Posted - 29 April 2002 :  13:31:47  Show Profile  Visit crash's Homepage
funny... would've thought to at least hear whether it worked out or not...



Crash's Site | Crash is from
Go to Top of Page

Steve D.
Average Member

USA
640 Posts

Posted - 06 May 2002 :  10:01:18  Show Profile  Visit Steve D.'s Homepage  Send Steve D. a Yahoo! Message
I just had the same problem. What I did to create the problem in the first place was to upload the topics.asp over my file, whoops.

So all I had to do is upload my topics.asp and everything worked like a charm.

----------------------------------------
Badges? We don't need no stinking badges
Go to Top of Page

Cyberjunkie
Junior Member

111 Posts

Posted - 06 May 2002 :  14:59:48  Show Profile
I'm having problems with this MOD. I have uploaded all the files (not the topic.asp) but when I go the the admin section to create the tables in my access 2000 database I cant find the Events MOD in the dropdown menu..hmm any suggestions?

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.34 seconds. Powered By: Snitz Forums 2000 Version 3.4.07