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
>
2
Replies
AdChoices