I have added an extra hidden field in the Forum_members table called "CodeField". As the name suggests its there to hold a hidden password that will provide access to specific parts of the site, depending on its value. Now at a separate part of a forum I want to be able to access the content of that field for the current user because depending on the value in that field they will be given access or not.
What is the code i need: to access and retrieve the value of "CodeField" for the current user ID?
This code should do it. It admits that you're including config.asp and inc_header.asp in the same page where you'll be doing this.
strSql = "SELECT CodeField FROM " & strMemberTablePrefix" & "MEMBERS WHERE " & strMemberTablePrefix & "MEMBER_ID=" & MemberID
set myRs = my_conn.execute(strSql)
if not myRs.EOF then myCodeField = myRs("CodeField")
myRs.Close
set myRs = nothing
When this code completes, MyCodeField will have the desired CodeField value.
Thanks Ruirib thats great! Just one more thing if it's ok, The field in question is a number field in the members table. What i want to do is include a checkbox in the pop_Profile.asp where I can either check it on or off. This checkbox will not be visible by the user as Iam setting the mlev to >3 so only the admin will see it. I promise this will be the last thing Iam going to ask, What is the code to inlude this field in the pop_profile.asp page? Ofcourse it has to be able to update the users record with the fields value.
We think of Snitz as an ASP learning experience. So, instead of writing the code for you I suggest that you try to do it. There are several checkbox fields in pop_profile.asp and inc_profile.asp. For example, M_RECEIVE_EMAIL. I would suggest that you have a look at the way this field is handled in both files and try to do the same... It shouldn't be too difficult. I don't have that much time to help people with mods, most my posts helping people don't require me to look at code, I just do it from the top of my head.
You can post for any doubts you have with this, but I suggest that you try to do it yourself.
thank you for your suggestion ruirib, I posted that late last night and was quite tired and I think a bit lazy to think about it properly... Point taken.
No problem. I'm sorry for not complying with your request, but I think I must draw the line somewhere, since I already post more than I should. Anyway I promise to assist you as you try it.
Topic Locked
Posted - 06 January 2003 : 04:36:55
