Web Wiz Forums - User Names vs Real Names

Print Page | Close Window

User Names vs Real Names

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=17225
Printed Date: 15 April 2026 at 11:33pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: User Names vs Real Names

Posted By: onceah
Subject: User Names vs Real Names
Date Posted: 11 November 2005 at 5:30pm

Hello everyone.

I install this forum on our intranet and it everything looks good. I need to have a small change. Maybe not small but change and I am not sure how to do it.

I want our users to login using their usernames but I want to have their real names to be displayed everywhere (who is logged it, topic starters, etc.....)

Is it possible to do?

Thank you.

Replies:

Posted By: dj air
Date Posted: 11 November 2005 at 5:56pm

you would have to edit any page that shows strUsername etc and get it so that it uses the real name field instead.

there would be quite a few pages

Posted By: onceah
Date Posted: 11 November 2005 at 6:15pm

This what I thought but the problem is that it does not work this way.

For example, on the page forum_topic.asp I changed all 3 entries related to Username. I changed it to Real_name. After that I have an error:

ADODB.Recordset error '800a0cc1'

Item cannot be found in the collection corresponding to the requested name or ordinal.

/mas/forum/forum_topics.asp, line 434

And I cannot do anything about this. There is something else or maybe I am missing something.

There is nothing else to change. Any ideas?

Thank you.

Posted By: dj air
Date Posted: 11 November 2005 at 6:19pm

its saying a field name is being wanted ot be used/requested but it was not called in within the query

can you paste around the section you are using, on lines 434, also highlight that line in red.

Posted By: onceah
Date Posted: 14 November 2005 at 9:12am

This is the text around line 434:

431: If NOT rsTopic.EOF Then

434:   strTopicStartUsername = rsTopic("Username")
435:   strFirstPostMsg = Mid(rsTopic("Message"), 1, 275)
436:   lngTopicStartUserID = CLng(rsTopic("Author_ID"))

I change Username to Real_name.

Also, I change this:

415:   If strDatabaseType = "SQLServer" Then
416:    strSQL = "EXECUTE " & strDbProc & "LastAndFirstThreadAuthor @lngTopicID = " & lngTopicID
417:   Else
418:    strSQL = "SELECT " & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Author_ID, " & strDbTable & "Thread.Message, " & strDbTable & "Thread.Message_date, " & strDbTable & "Author.Username "
419:    strSQL = strSQL & "FROM " & strDbTable & "Author, " & strDbTable & "Thread "
420:    strSQL = strSQL & "WHERE " & strDbTable & "Author.Author_ID = " & strDbTable & "Thread.Author_ID AND " & strDbTable & "Thread.Topic_ID = " & lngTopicID & " "
421:    strSQL = strSQL & "ORDER BY " & strDbTable & "Thread.Message_date ASC;"
422:   End If

on line 418 I change Author.Username to Author.Real_name.

There is one more place that I change:

444:    lngLastEntryMessageID = CLng(rsTopic("Thread_ID"))
445:    strLastEntryUsername = rsTopic("Username")
446:    lngLastEntryUserID = CLng(rsTopic("Author_ID"))
447:    dtmLastEntryDate = CDate(rsTopic("Message_date"))

On line 445 I change Username to Real_name.

I do not think that there is anything else to change on this page but it gives me an error.

Thank you.

Posted By: dj air
Date Posted: 14 November 2005 at 9:51am

if those parts where changed then its ok, are you using the MS SQL or Access version?

it seems the queries are wrong, if using the MS SQL version you need to edit the stored procedures not the SQL you see there,

Posted By: onceah
Date Posted: 14 November 2005 at 10:07am

I use MS SQL. Could you please point me to what stored procedure should I update? Are there different stored procedures for different pages or is there only one?

Thank you.

Posted By: dj air
Date Posted: 14 November 2005 at 10:23am

LastAndFirstThreadAuthor

is used on some you will have to be careful because some places do searchs on username so you will have to look though the SQL server setu p file and see what files reflect using username

im not sure how you are doing this but you could have issues