Web Wiz Forums - Getting username from cookie(?)

Print Page | Close Window

Getting username from cookie(?)

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=9432
Printed Date: 07 April 2026 at 8:16pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Getting username from cookie(?)

Posted By: safranko
Subject: Getting username from cookie(?)
Date Posted: 01 February 2004 at 12:18am

I'm kinda new to asp, so I'm trying to figure this out. I would like my main page on my website (not the forum) to show the username and a welcome message if the user is currently logged in. Is the username stored in a cookie? If so, what is the name of the cookie. If not, is there anyway to do what I'm asking?

Please help! Thanks.

Replies:

Posted By: thekiwi
Date Posted: 01 February 2004 at 12:43am

safranko wrote:

Please help! Thanks.

Try something like:


<!--#include file="/forum/common.asp" -->
<% 
 ' Collect Username from database using available WWF Cookie.
 strSQL = "SELECT " & strDbTable & "Author.Username" _
   & " FROM " & strDbTable & "Author " _
   & " WHERE " & strDbTable & "Author.User_code = '" & Request.Cookies(strCookieName)("UID") & "';"
 'Query the database
 rsCommon.Open strSQL, adoCon
 if rsCommon.EOF then
  Status = False ' We cant find their details, or the Cookie was blank
 else
  Status = True
  Username = rsCommon("Username")
 end if
 %>

Assuming your fourm is located in /forum/

-------------
Cheers
TheKiwi
http://www.infobahn.co.nz - Internet Infobahn - website design and hosting