Author |
Topic  |
|
leska
Starting Member
9 Posts |
Posted - 21 February 2005 : 03:57:00
|
I'm integrating forum in my web site and experienced the following: on my home page (in the root directory, snitz is in the "forum" subdirectory) I'm trying to insert a link to member's profile:<!--#include file="forum/inc_func_common.asp"-->
<!--#include file="forum/inc_func_secure.asp"-->
<html><head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1250">
</head><body>
User: <%
strMemberName = Request.Cookies("Snitz00User")("Name")
if strMemberName= "" then
response.write "n/a (<a href='forum/login.asp?target=..'>login</a>)"
else
response.write "<a href='forum/pop_profile.asp?mode=display&id='>" &getMemberID(strMemberName) &"</a>"
end if
%>
</body></html>
but I get: "ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/Metodologija/forum/inc_func_secure.asp, line 74"
Any idea how to solve this?
Thanks in advance! |
|
grupe
Starting Member
10 Posts |
Posted - 21 February 2005 : 13:54:00
|
response.write "<a href='forum/pop_profile.asp?mode=display&id='>" &getMemberID(strMemberName) &"</a>"
Should Be:
response.write "<a href='forum/pop_profile.asp?mode=display&id='>" & getMemberID(strMemberName) & "</a>"
I have seen the lack of correct spacing be an issue |
 |
|
masterao
Senior Member
   
Sweden
1678 Posts |
Posted - 21 February 2005 : 15:05:18
|
That link does not contain the querystring-id of the member you want to view (that value is shown as the linked text). The link should look like this:
"<a href='forum/pop_profile.asp?mode=display&id='" &getMemberID(strMemberName) &"'>" & strMemberName & "</a>" |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
 |
|
leska
Starting Member
9 Posts |
Posted - 22 February 2005 : 02:25:55
|
Thanks both. But this doesn't seem to work either, even if I move the file to the /forum directory:
<!--#include file="inc_func_common.asp"-->
<!--#include file="inc_func_secure.asp"-->
<html><head></head><body>User: <%
strMemberName = Request.Cookies("Snitz00User")("Name")
if strMemberName= "" then
response.write "n/a (<a href='forum/login.asp?target=..'>login</a>)"
else
response.write "<a href='forum/pop_profile.asp?mode=display&id=" & getMemberID(strMemberName) & "'>" & strMemberName & "</a>"
end if %>
</body></html> |
 |
|
masterao
Senior Member
   
Sweden
1678 Posts |
|
leska
Starting Member
9 Posts |
Posted - 22 February 2005 : 16:08:03
|
quote: Originally posted by masterao
You need to include config.asp as well.
Thanx, but it doesn't help either. Now I get this error:
ADODB.Recordset error '800a0e7d' Operation is not allowed on an object referencing a closed or invalid connection. /Metodologija/forum/inc_func_secure.asp, line 74
|
 |
|
Shaggy
Support Moderator
    
Ireland
6780 Posts |
Posted - 23 February 2005 : 05:15:25
|
You'll also need to open your database connection. Have a look in inc_header.asp to see how to do so. (Look for my_conn.open)
|
Search is your friend “I was having a mildly paranoid day, mostly due to the fact that the mad priest lady from over the river had taken to nailing weasels to my front door again.” |
 |
|
leska
Starting Member
9 Posts |
Posted - 24 February 2005 : 15:50:47
|
Still not working . I put following lines at the top of my code:
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\inetpub\MetodologijaForum.mdb"
set my_Conn= Server.CreateObject("ADODB.Connection")
my_Conn.Open strConnString
|
Edited by - leska on 24 February 2005 15:51:26 |
 |
|
masterao
Senior Member
   
Sweden
1678 Posts |
|
leska
Starting Member
9 Posts |
Posted - 02 March 2005 : 04:55:24
|
quote: Originally posted by masterao
Did you get any error messages after adding that? If so, what was the error message?
At the time I get no error message (except "Page could not be displayed..."). Today I checked once more and it works! Don't ask me how Thanks you all!
Now I have similar problem: near Username profile link I also want to add a logout link. Is there an easy way to do this?
|
 |
|
masterao
Senior Member
   
Sweden
1678 Posts |
|
|
Topic  |
|