You could set a hidden variable to check if they've submitted the form. If they have, don't show the form fields/submit button - use a cfif to skip over that and instead generate a "thanks for submitting" message or something.
<cfparam name="form.didsubmit" default=0> <cfif form.didsubmit> do db entry here </cfif> <cfif not form.didsubmit> <form> <input type="hidden" name="didsubmit" value=1> rest of form </form> <cfelse> Thanks message </cfif> -- Josh ----- Original Message ----- From: "Scott Stroz" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, May 31, 2006 11:14 AM Subject: Re: FORM Action=GET Clear out URL Parameters after Submit > CJ/Jochem, your suggestions alone still won't solve the issue of a new > record being created if a user refreshes a page. Yea, they will get the > window asking if they want to submit the form again, but if they click > 'OK' > then a new record will be created. > > On 5/31/06, Jochem van Dieten <[EMAIL PROTECTED]> wrote: >> >> James Blaha wrote: >> > >> > Is there a way when you have a self submitting cfm page to insert a >> record and clear out the forms URL parameters so if a user refreshes the >> template another record doesn't get inserted? >> >> Since using a GET to change data on the server goes directly >> against RFC 2616 9.1.1 I think you will find any workaround that >> may be suggested extremely unreliable. Use POST if the request >> changes data on the server. That is what POST was invented for. >> >> Jochem >> >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241851 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
