Skip to main content
Participant
August 26, 2007
Question

Return to updated record

  • August 26, 2007
  • 4 replies
  • 335 views
I created an update page awhile back and used Dreamweaver to write the code. The update is successful, but the index is set to the beginning of the recordset when completed. I can't seem to find where this is happening...any suggestions?

Thanks so much for any help.
This topic has been closed for replies.

4 replies

eacollie1Author
Participant
August 26, 2007
Thanks David.

I'll try that.
Inspiring
August 26, 2007
eacollie1 wrote:
> Perhaps I should make a separate edit page?

Yes, I think so. The normal way is to create a list of all records,
together with links to update and delete forms. If a separate form
handles the update, you can redirect the user to wherever you want
afterwards.

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/
eacollie1Author
Participant
August 26, 2007
Thank you David.

I guess I'm not sure what the code is doing in Dreamweaver. It created a form and a navigation series of buttons (first, previous, next, and last). I created a button for editing the existing record and, when the user clicks this button, it redirects to the form and runs an update statement. This works and the record is updated; however, it goes back to the first record in the recordset.

Perhaps I should make a separate edit page?
Inspiring
August 26, 2007
eacollie1 wrote:
> I created an update page awhile back and used Dreamweaver to write the code.
> The update is successful, but the index is set to the beginning of the
> recordset when completed. I can't seem to find where this is happening...any
> suggestions?

See this thread in the main Dreamweaver forum:

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=189&threadid=1294897&enterthread=y#4687934

--
David Powers, Adobe Community Expert
Author, "The Essential Guide to Dreamweaver CS3" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/