Forums
This topic is locked
User Specific Information?
Posted 27 Sep 2002 15:42:10
1
has voted
27 Sep 2002 15:42:10 Brian Dunk posted:
Hello, I have an address book, populated by registration, using an Access db that has update and delete links after each registered user. I would like to display the update and delete link only to the user that has logged in. Is this possible using VB ASP pages? I.E I log in as bdunk and i would see the update and delete link next to my name only. thanks so much. Bdunk Replies
Replied 27 Sep 2002 16:54:54
27 Sep 2002 16:54:54 Stuart Harland replied:
At the sucessful login process you could set session variables of the users uid/pwd.
Then if their name/ pass equals a record with the same uid/pwd then display the images/ links for editing/ deletion.
Roughly like this:
'if username and password entered match a record then:
Session("Name"= rs("Name"
Session("ID"=rs("ID"
Then in all your pages you can open recordsets with:
rsData = "select * from tblData"
And when you get to where the graphics for edit/ delete go on your html:
If rsData.userName = Session("Name" AND rsData.userID = Session("ID" then
'display the graphics/ links to edit/ delete
End If
********************
wheatNOTmeat
Then if their name/ pass equals a record with the same uid/pwd then display the images/ links for editing/ deletion.
Roughly like this:
'if username and password entered match a record then:
Session("Name"= rs("Name"
Session("ID"=rs("ID"
Then in all your pages you can open recordsets with:
rsData = "select * from tblData"
And when you get to where the graphics for edit/ delete go on your html:
If rsData.userName = Session("Name" AND rsData.userID = Session("ID" then
'display the graphics/ links to edit/ delete
End If
********************
wheatNOTmeat