yeah, I thought about that afterwards. somewhere I have done it and I don't remember what I did. I think I had set a session and used that as the default value for the hidden field and added +1. So if it was more that 1 it gave the error message.
I told u I don't know crap, lol ----- Original Message ----- From: "Charlie Griefer" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, June 10, 2003 4:24 PM Subject: Re: Prevent Refresh > wouldn't that fire every time the form was submitted? > > and if refresh was pressed on the form's action page...how would it prevent > the data from re-posting? > > ----- Original Message ----- > From: "Dave Lyons" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Tuesday, June 10, 2003 1:04 PM > Subject: Re: Prevent Refresh > > > > can always add a hidden field to the form with a specified value > > and then on the processing page add something like: > > > > <!--- check for duplicate form submissions ---> > > <cfif #form.submissionCheck# EQ "submitted"> > > Geezo have some patients, you already submitted the form! > > </cfif> > > > > but then again, i know jack squat about cf > > > > > > > > > > > > ----- Original Message ----- > > From: "Charlie Griefer" <[EMAIL PROTECTED]> > > To: "CF-Talk" <[EMAIL PROTECTED]> > > Sent: Tuesday, June 10, 2003 3:42 PM > > Subject: Re: Prevent Refresh > > > > > > > I agree with just about everything Isaac said, but wanted to chime in > and > > > say that the easiest solution would be the <cflocation> on the form's > > action > > > page. This is generally how I prevent the duplicate submissions. > > > > > > The form's action page contains no HTML, just the insert query. After > the > > > query successfully runs, I do a <cflocation> to a "Thank You" page. > This > > > way, a refresh only refreshes that page. > > > > > > > > > > > > ----- Original Message ----- > > > From: "S. Isaac Dealey" <[EMAIL PROTECTED]> > > > To: "CF-Talk" <[EMAIL PROTECTED]> > > > Sent: Tuesday, June 10, 2003 12:34 PM > > > Subject: Re: Prevent Refresh > > > > > > > > > > > What is best way of preventing multiple entries in DB > > > > > through form > > > > > submission when user clicks on REFRESH or BACK button of > > > > > browser? > > > > > > > > > Thanks > > > > > Shaz > > > > > > > > I usually use cflocation to move the browser to a confirmation > template > > > which informs the user that the record has been updated. > > > > > > > > In my case, this is often the form page, or in other words, they go > back > > > to the form with a "information saved" confirmation message at the top > of > > > the form, usually with all the info they just enterred filled in on the > > form > > > again. I also like to use the pengoworks qForms API (www.pengoworks.com) > > to > > > prevent multiple form submissions in browsers that support the DOM. If I > > > have to use cfflush on a page, > > > > > > > > I move from cflocation to the javascript location.replace() which does > > the > > > same thing client-side by replacing the current address in the browser > > > history. It's available in Netscape as far back as version 3 and IE > > > similarly. I'm not certain about other browsers, although I would assume > > at > > > least Mozilla supports it since it was implemented in NS prior to > Mozilla > > > becoming available. There's a UDF implementation of it in the Tapestry > API > > > in my sig file also. > > > > > > > > hth > > > > > > > > s. isaac dealey 972-490-6624 > > > > > > > > new epoch http://www.turnkey.to > > > > > > > > lead architect, tapestry cms http://products.turnkey.to > > > > > > > > tapestry api is opensource http://www.turnkey.to/tapi > > > > > > > > certified advanced coldfusion 5 developer > > > > http://www.macromedia.com/v1/handlers/index.cfm?ID=21816 > > > > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4