Add author info in posts
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums Modifications
Forum Description: Mod's and Add-on's for Web Wiz Forums.
URL: https://forums.webwiz.net/forum_posts.asp?TID=29010
Printed Date: 28 March 2026 at 7:54am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Add author info in posts
Posted By: claustrier
Subject: Add author info in posts
Date Posted: 11 December 2010 at 2:40pm
|
Hi
I am trying to add some additional infos about the author in the posts (forum_posts.asp)
I already have the tblAuthor up and running with the extra fields, and displaying these on memper_profile.asp - works with no problems.
But trying to display these 2 extra fields on the forum_posts.asp is another matter - mainly because I do not understand the logic of the asp, I believe ;-)
I understand I must first add (around line 147)
Dim strHjemmeklub
Dim strHandicap Then I thought I could just add (around line 1106)
strHjemmeklub = sarryPosts(20,intCurrentRecord)
strHandicap = sarryPosts(21,intCurrentRecord)
and finally display the results (around line 1233)
If strHjemmeklub <> "" Then Response.Write(vbCrLf & " <br />" & strTxtHjemmeklub & ": " & strHjemmeklub)
If strHandicap <> "" Then Response.Write(vbCrLf & " <br />" & strTxtHandicap & ": " & strHandicap)
...but this gets me an out of range error. HOW do I add these 2 fields succesfully??? Any help greatly appreciated!!
|
Replies:
Posted By: Scotty32
Date Posted: 13 December 2010 at 8:06pm
|
The problem is a simple one. You have forgotten to add the new Fields to the SQL statement. Look for the following line around 574:
Add to the end of this line (inside the quotation tags) your new fields. Make sure to add " & strDbTable & "Author. to the start of the field name just like the others in the string. Also add the fields in the order you wish to access them (eg strHjemmeklub should be first added) ------------- S2H.co.uk - http://www.s2h.co.uk/wwf/" rel="nofollow - WebWiz Mods and Skins For support on my mods + skins, please use http://www.s2h.co.uk/forum/" rel="nofollow - my forum . |
strSQL = strSQL & strDbTable & "Thread.Thread_ID, " & strDbTable & "Thread.Message, " & strDbTable & "Thread.Message_date, " & strDbTable & "Thread.Show_signature, " & strDbTable & "Thread.IP_addr, " & strDbTable & "Thread.Hide, " & strDbTable & "Author.Author_ID, " & strDbTable & "Author.Username, " & strDbTable & "Author.Homepage, " & strDbTable & "Author.Location, " & strDbTable & "Author.No_of_posts, " & strDbTable & "Author.Join_date, " & strDbTable & "Author.Signature, " & strDbTable & "Author.Active, " & strDbTable & "Author.Avatar, " & strDbTable & "Author.Avatar_title, " & strDbTable & "Group.Name AS GroupName, " & strDbTable & "Group.Stars, " & strDbTable & "Group.Custom_stars, " & strDbTable & "GuestName.Name AS GuestName "Posted By: alimvelim
Date Posted: 05 January 2011 at 8:40am
| thanks. |