record update not working

I would check where your success page is getting its values from as it
sounds like they are form values rather than a refresh of the database data.

The most common mistake with updates is not having a field that will hold
the unique record ID so that the data can update properly, or not having the
hidden form field that MM uses to test that the submit has been pressed.

--
Paul Whitham
Certified Dreamweaver MX2004 Professional
Adobe Community Expert - Dreamweaver

Valleybiz Internet Design
www.valleybiz.net

"gfoulks" <webforumsuser@macromedia.com> wrote in message
news:ep5u6q$q2k$1@forums.macromedia.com...
> New jsp page created and I used the Insert-Application Objects-Update
> Record-Record Update Form Wizard
>
> The wizard said I needed to create the recordset set first. Completed the
> step
> and then created the update form.
>
> When I load the page the form field is loaded with the current value of
> the
> database field. I enter in the new text and click submit. The goto page
> after
> update loads (which basically displays the new data for the column on the
> page)
> and the old data is still in the table.
>
> I've logged into the DB after the update and ran a query and found that
> the
> record was not updated at all.
>
> Question
> 1) How is the goto page after update able to even load if the table was
> not
> updated?
>
> 2) Where did my data go and why is it not updating the table?
>
> Thanks,
> Greg
>