Web Wiz Support and Community Forums : User Names vs Real Names https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Wed, 15 Apr 2026 23:41:14 +0000 Mon, 14 Nov 2005 10:23:49 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=17225 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[User Names vs Real Names : LastAndFirstThreadAuthor is...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93818.html#93818 Author: dj air
Subject: 17225
Posted: 14 November 2005 at 10:23am

LastAndFirstThreadAuthor


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

im not sure how you are doing this but you could have issues
]]> Mon, 14 Nov 2005 10:23:49 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93818.html#93818 <![CDATA[User Names vs Real Names : I use MS SQL. Could you please...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93815.html#93815 Author: onceah
Subject: 17225
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.]]> Mon, 14 Nov 2005 10:07:30 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93815.html#93815 <![CDATA[User Names vs Real Names : if those parts where changed then...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93810.html#93810 Author: dj air
Subject: 17225
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,
]]> Mon, 14 Nov 2005 09:51:59 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93810.html#93810 <![CDATA[User Names vs Real Names : This is the text around line 434:...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93806.html#93806 Author: onceah
Subject: 17225
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.
]]> Mon, 14 Nov 2005 09:12:58 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93806.html#93806 <![CDATA[User Names vs Real Names : its saying a field name is being...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93689.html#93689 Author: dj air
Subject: 17225
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.
]]> Fri, 11 Nov 2005 18:19:22 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93689.html#93689 <![CDATA[User Names vs Real Names : This what I thought but the problem...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93686.html#93686 Author: onceah
Subject: 17225
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.
]]> Fri, 11 Nov 2005 18:15:56 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93686.html#93686 <![CDATA[User Names vs Real Names : you would have to edit any page...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93681.html#93681 Author: dj air
Subject: 17225
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
]]> Fri, 11 Nov 2005 17:56:56 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93681.html#93681 <![CDATA[User Names vs Real Names : Hello everyone. I install this...]]> https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93676.html#93676 Author: onceah
Subject: 17225
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.
]]> Fri, 11 Nov 2005 17:30:22 +0000 https://forums.webwiz.net/user-names-vs-real-names_topic17225_post93676.html#93676