Record display to match log in user

[joe955]

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.

[DwFAQ]

Heya Joe,

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

Hope that helps!

[joe955]

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.

[DwFAQ]

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!