Search for and Update Records

It is fairly straightforward but there are a few steps involved.

1. Create the "update page" - this is the page where the data will display
and where it can be edited.
2. On that page create a form with fields similar to the registration page.
(you can even make a copy of the reg page to start with)
3. Create a recordset - if you've used the DQ logon user behavior you can
Select all fields from the table where the data is stored based on the
MM_Username Session variable.
4. Go to Bindings - from there drag the table fields to the form fields on
the page. This works for text fields. For dropdowns and lists, click the
dynamic data button and select the fields from the recordset.

Now, when this page loads it will display the data from the user's record.

To update - create an update record behavior - that works the same as the
registration.

HTH


"Sid Childers" <webforumsuser@macromedia.com> wrote in message
news:e5n9mu$slo$1@forums.macromedia.com...
> Good Morning,
>
> I'm developing a site that allows users to input registration data. They
> are
> able to successfully insert records into the MySQL database. However, my
> problem is that I need to add functionality so that they can retrieve the
> record they've created and make changes (update) it.
>
> I've read a lot of the help topics about creating search results pages but
> am
> confused. Here's how I would like the process to flow: When user logs
> in,
> they are taken to a page that allows them to select their own record to
> edit
> based on email address (not unique). Once they choose the record to edit,
> an
> update record page loads that presents them with the opportunity to
> correct any
> data fields.
>
> I'm a very young newbie and greatly appreciate any assistance. Thanks
>