RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-24 Thread Charlie Arehart
Going back to this question from last week, I didn't see anyone mention the feature built into CF 7 and above to prevent duplicate form submissions. It's a simple solution (which of course means it has both pros and cons): using CFINPUT TYPE=submit VALIDATE=submitonce NAME=somename within a

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Dean H. Saxe
Put a unique identifier in the form request, store it in the user's session before form submission. Once the form is submitted check to see if the value matches. If so delete it from the session and continue processing. If the token doesn't match or is nonexistent in the session, then

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Douglas Knudsen
My first thought is...disable the submit button after its mashed once. My second thought is, some people disable JavaScript. Now, what type of user disables JavaScript? Would that type of user go 'mash the button crazy', does it really matter then? If so, could use Flash(read Flex). Aside

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Kevin Hellriegel
I think validating before submitting makes sense (less bandwidth if users are submitting large files for example). I use mxAjax [ http://www.indiankey.com/mxajax/] for simple validations/lookups in applications I've written. It is fairly simple to set up and use. You create a CFC, add it to the

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Dean H. Saxe
I'm one of those users. NoScript is a very good extension if you want to know what marketing companies and other unsavory types are harvesting your surfing habits to target advertising. I enable scripting on a whitelist of trusted sites only. -dhs Dean H. Saxe, CISSP, CEH [EMAIL

RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Fennell, Mark P.
A couple of things spring to my mind that don't involve ajax. 1. Accept the form and then prompt for the upload. It adds a separate page but it reduces your duplication. 2. Accept the uploaded document. Yep, save it to your server and if the data turns out to be a duplicate entry, action=DELETE

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Dean H. Saxe
You ABSOLUTELY MUST validate after submission on the server. And if you want to stop duplicate submissions, this must be done server side. ANY client side validation is trivial to bypass. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Dissent is the purest form of patriotism.

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Jeff Howard
These duplicates are not necessarily session duplicates. A user, or even a different user might input the same information from a hard-copy form into the system a day or two later. Basically, I'm trying to look into the database and compare all fields values with those of the submitted form, and

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Steven Ross
You could still go this route and make the form so that the button is disabled by default and only gets enabled if JS is on... that circumvents the is JS on problem. I've worked on forms in the past and used this approach. You have the potential of cutting out the people that have JS turned off

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Jeff Howard
My first quick fix idea was to run the check, if recordcount GT 0 then throw the form into wddx and put it in a temp table in the db. if user click 'save' pull the info back out and save and delete the wddx record from the temp table. if the user clicks 'cancel', just delete the temp file. this

RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread axunderwood
Of Jeff Howard Sent: Thursday, March 20, 2008 11:20 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions These duplicates are not necessarily session duplicates. A user, or even a different user might input the same information from a hard-copy

RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Fennell, Mark P.
. Saxe Sent: Thursday, March 20, 2008 11:16 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions I'm one of those users. NoScript is a very good extension if you want to know what marketing companies and other unsavory types are harvesting your

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Jeff Howard
This is an internal application and js is enabled on all machines and everyone MUST use IE here. The issue here is that the user must be the one to decide if it is a duplicate. I'm merely notifying the user that there is a submission already that looks identical to what they submitted. Then

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Dean H. Saxe
Ajax does not solve your problem. Ajax is a series of methods for UI control, not business logic. Regardless of your use of Ajax or not you have a business problem to solve first, implementation and UI control comes later. -dhs Dean H. Saxe, CISSP, CEH [EMAIL PROTECTED] Free speech

Re: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Dean H. Saxe
them the ability to view those other entries before saving the form). Just an idea. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Thursday, March 20, 2008 11:20 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form

RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Dusty Hale
Howard Sent: 03/20/2008 11:45 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions This is an internal application and js is enabled on all machines and everyone MUST use IE here. The issue here is that the user must be the one to decide

RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Kitchens, Brent
University From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Thursday, March 20, 2008 11:45 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions This is an internal

RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Shane Heasley
What Dean said. Shane CTek Media -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dean H. Saxe Sent: Thursday, March 20, 2008 10:03 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions Put

RE: [ACFUG Discuss] looking for opinions on duplicate form submissions

2008-03-20 Thread Dusty Hale
the db and no possible duplicates then skip screen 2. _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: 03/20/2008 11:45 AM To: discussion@acfug.org Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form submissions This is an internal