The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
I want the Thank you message in post_info.asp to add the users title and name at the end.
I know I can use "" & strDBNTUserName & "" to add the name but not sure of the title can anyone help me please?
<
I know I can use "" & strDBNTUserName & "" to add the name but not sure of the title can anyone help me please?
<
نوشته شده در
There's really no "quick" way to do it, since the title is not stored in any forum variables. If you only want to use it in that one location, it would be as simple as running a quick SQL query to get the user's title from the database and use it on post_info.asp. However, if you think you'll want to use it in other places as well, you might consider adding the code to inc_header.asp and storing it in a variable for use throughout your site.<
نوشته شده در
Thanks for the info
Could you help me with the code for that please?
I really lack knowledge<
Could you help me with the code for that please?
I really lack knowledge<
نوشته شده در
I am on my way out the door just at the moment, but if nobody has replied when I get home this evening, I'll take a look. It should only be a couple lines of code.<
نوشته شده در
Thanks alot 
<
<
نوشته شده در
This is untested, but it should work for you. You can include it in post_info.asp or in inc_header.asp, which will give you a little more flexibility with using the title on other pages.
<
Code:
strSql = "SELECT M_TITLE FROM " & strMemberTablePrefix & "MEMBERS WHERE MEMBER_ID = " & MemberID
set rsMTitle = Server.CreateObject("ADODB.Recordset")
rsMTitle.open strSql, my_Conn
MemberTitle = rsMTitle("M_TITLE")
rsMTitle.close
set rsMTitle = nothing