Gerald, You can also disable the submit button once it has been pressed to prevent the form from being submitted again that way.
Of course there is always more than one way to submit the form. But that should help. Maybe instead of submitting the form directly, use a JavaScript preSubmit() function with a check to see if a submit is in progress and prevent another one from occurring again. Ricardo. On 9/28/06, Gerald Weir <[EMAIL PROTECTED]> wrote: > Hi Jon, > I'll give that a try. I was astounded just now that when I went to our site > and tried to sign up for the newsletter I tried to just keep clicking on the > SUBMIT button and low-and-behold I see my email address in the database 6 > times in a row. I thought that was a submit button was pushed that was it! > Guess not. > > I'll try this cflock approach. > > Jerry > > >I would suggest wrapping from the before the beginning of the e-mail > >check query to the end of the insert query. You simply want to lock > >that block from being executed by another user. Then your <cfmail> > >transaction, which may take a bit longer, isn't under lock if you > >have concurrent users. > > > ><cftransaction> allows you to rollback in the event of a failure you > >designate. It doesn't, however lock anything. > > > >Jon > > > >On Sep 27, 2006, at 12:56 PM, Gerald Weir wrote: > > > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254567 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
