M
member 37483
Guest
I am trying to build an asp that the user could edit their own user information on it after they log in. Any clues on how is the best/easiest way for me to do this.
John
John
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
eg.
after validating you store the userid in a session variable
session("sUserId"
= cUserID
your 'Update my info page' now uses this session variable to build the right SQL-statement:
cSQL = "SELECT TOP 1 * FROM USERS WHERE UserID = '" &_
session("sUserID" & "'"
the rest is obvious...
[this is just 1 idea to solve this puzzle]
br
Gerard
after validating you store the userid in a session variable
session("sUserId"
= cUserIDyour 'Update my info page' now uses this session variable to build the right SQL-statement:
cSQL = "SELECT TOP 1 * FROM USERS WHERE UserID = '" &_
session("sUserID"
& "'"the rest is obvious...
[this is just 1 idea to solve this puzzle]
br
Gerard
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question