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

 All Forums
 Snitz Forums 2000 DEV-Group
 DEV Discussions (General)
 How to link to member's profile?		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

leska
Starting Member

9 Posts
Posted - 21 February 2005 :  03:57:00  Show Profile
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  Show Profile
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
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts
Posted - 21 February 2005 :  15:05:18  Show Profile  Visit masterao's Homepage
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
Go to Top of Page

leska
Starting Member

9 Posts
Posted - 22 February 2005 :  02:25:55  Show Profile
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>
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts
Posted - 22 February 2005 :  15:39:32  Show Profile  Visit masterao's Homepage
You need to include config.asp as well.
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page

leska
Starting Member

9 Posts
Posted - 22 February 2005 :  16:08:03  Show Profile
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
Go to Top of Page

Shaggy
Support Moderator

Ireland
6780 Posts
Posted - 23 February 2005 :  05:15:25  Show Profile
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.”
Go to Top of Page

leska
Starting Member

9 Posts
Posted - 24 February 2005 :  15:50:47  Show Profile
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
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts
Posted - 24 February 2005 :  16:23:17  Show Profile  Visit masterao's Homepage
Did you get any error messages after adding that? If so, what was the error message?
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
Go to Top of Page

leska
Starting Member

9 Posts
Posted - 02 March 2005 :  04:55:24  Show Profile
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?
Go to Top of Page

masterao
Senior Member

Sweden
1678 Posts
Posted - 02 March 2005 :  17:12:05  Show Profile  Visit masterao's Homepage
Im glad you got it working .
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod
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.14 seconds. Powered By: Snitz Forums 2000 Version 3.4.07