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!!
Topic Options
Post Options
Thanks(0)
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 "