After the page submits and everything is successful, have the page do a CFLOCATION to itself. Then, any subsequent refreshes will only refresh the last page load.
M!ke -----Original Message----- From: Discover Antartica [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 09, 2005 11:49 AM To: CF-Talk Subject: Refreshing the page gives problems The form in the page is submitting to the same page. If the user refreshes the page, then, the query to insert the record filled out in the form is executed again. So, the number of records in the table keep increasing. is there a way to prevent this? The primary key in the table the data is being inserted is a counter that increments itself. It is not part of the query that is inserting the new records. merci! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:193929 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
