RE: history from update
Well if it is the result of a form submittal you could just use a time limit then take them back or just use the onload function (obviously the "thankyou for submitting the form" message wont be displayed then though") -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: 25 April 2002 15:42 To: CF-Talk Subject: FW: history from update Thanks for the replies, I'll make it much simpler: How do I use the "history.go(-1)" to automatically bring the user back to the previous page without use a BACK button or hyperlink? > Thanks. > > Robert O. > __ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: history from update
Just use the history.go(-1) after updating the db in your update.cfm page Thanks, Dave -Original Message- From: Robert Orlini [mailto:[EMAIL PROTECTED]] Sent: Thursday, April 25, 2002 9:25 AM To: CF-Talk Subject: history from update Hello, I have a display page that includes certain fields that are updated. When the user clicks the "UPDATE" it goes to an update.cfm page. I've included a "BACK to Query Results page" button with a onClick="history.go(-1)" script in the update.cfm page to go back after the update has been made. What I would like is after the user clicks "UPDATE" and the field(s) are updated by the update.cfm page it would automatically return them to the original page with the "updated" fields w/o clicking any "BACK to Query Results page" button. Any ideas or suggestions? I'm thinking but I don't think it is good. Thanks. (code for update.cfm below) Robert O. UPDATE wweb SET Status = '#form.statuslist#', Activatedby = '#Form.activatedby#' Where ID = #form.ID# Record has been updated. __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: history from update
Try something like this (not real code, just a logic path): * If this is the initial time to the form, query for current data in the database and prepopulate form. * Allow user to make changes; form submits to itself. * a SQL UPDATE statement would happen on the template before the new data for the form is queried for... * ...after this is processed, query for data, and form will be populated with new data So, UPDATE SELECT data Data has been updated Form goes here Or something like that... Pete - Original Message - From: "Robert Orlini" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, April 25, 2002 9:25 AM Subject: history from update > Hello, > > I have a display page that includes certain fields that are updated. When the user clicks the "UPDATE" it goes to an update.cfm page. I've included a "BACK to Query Results page" button with a onClick="history.go(-1)" script in the update.cfm page to go back after the update has been made. > > What I would like is after the user clicks "UPDATE" and the field(s) are updated by the update.cfm page it would automatically return them to the original page with the "updated" fields w/o clicking any "BACK to Query Results page" button. > > Any ideas or suggestions? I'm thinking but I don't think it is good. > > Thanks. (code for update.cfm below) > > Robert O. > > > > > UPDATE wweb SET Status = '#form.statuslist#', Activatedby = '#Form.activatedby#' > Where ID = #form.ID# > > > Record has been updated. > > > > __ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists