Skip to main content
joe955
Known Participant
March 7, 2009
Question

Record display to match log in user

  • March 7, 2009
  • 3 replies
  • 468 views
I'm trying to create a log in area with user information. I have used the update record and it does display a record but only the first record that I input no matter what username I log in with. I want to have the record display match the logged in users information.
This topic is closed to new replies. Start a new post to keep the conversation going.

3 replies

DwFAQ
DwFAQ
Participating Frequently
March 8, 2009
Heya Joe,

Try this:

1. Restrict access to page for logged in users.

2. Create form you'll use for Update Record Server Behavior.

3. Add a hidden field in the form for primary_key name and id = primary_key

4. Add the value for primary_key as the session login_id from the Bindings Tab in Dreamweaver.

5. Add Update Record Server Behavior. Select primary_key form field for integer primary key in Update Record SB and add other form fields corresponding to update record accordingly.

6. save, put, login, visit, update logged in users record.

Hope that helps!
DwFAQ
DwFAQ
Participating Frequently
March 7, 2009
Heya Joe,

Adjust your query to UPDATE table FROM table WHERE id = session login id

Hope that helps!
joe955Author
Known Participant
March 7, 2009
Ok but DreamWeaver doesn't seem to let me just type that in. I have to SELECT table. I tried a few combinations but I don't think I understand how to modify the query other than through editing the recordset.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices