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 CFFORM. Before you declare it a show-stopper for requiring CFFORM, or for using Javascript (which it builds for you), at least give it some thought.
I've got a blog entry with many more details and some sample code you can use to demonstrate the feature and its solution, which I wrote tonight as sparked by this discussion, at "Stopping multiple form submissions with CF 7/8 and "submitonce" validation" http://carehart.org/blog/client/index.cfm/2008/3/24/prevent_multiple_form_su bmissions One other thing I discuss there, which I don't recall being mentioned in this thread: Firefox already solves the problem for you, preventing multiple form submissions. But unless you can guarantee that all your users will use that, you need to be prepared to solve the problem yourself. The CF-based feature does the trick nicely. /charlie From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard Sent: Thursday, March 20, 2008 10:52 AM To: discussion@acfug.org Subject: [ACFUG Discuss] looking for opinions on duplicate form submissions I'm working on an application where a form is submitted along with various attachments (doc, pdf, xls, etc). Apparently users are submitting the same request several times and I've been asked to address this issue. At first thought, it seemed quick and simple to me, but as I've started working on it I can't decide exactly how to handle the attachments in associated with the form in the most efficient way. That brings me here. I was looking for suggestions on how to handle the attachments while I run validation on the db to see if the input from the form already exists in the db. It seems like something that would be perfect for AJAX to handle, but my AJAX skills are virtually nonexistent. So, without using AJAX (or if you can break it down using AJAX for a novice) how would you handle the situation? The main issue I'm having, is that if I do the validation after the form submission, CF is assigning a temp directory to my attachment file. So what is submitted as this: "C:\Documents and Settings\JHoward\Desktop\PO Request mods.doc" ends up as this after submission and validation: "C:\ColdFusion8\runtime\servers\coldfusion\SERVER-INF\temp\wwwroot-tmp\neotm p13963.tmp " and then when I pass it to the CFFILE, it tells me the file doesn't exist. I'm really just looking at the different ways other people would handle this situation to try and decide so any input would be great. Thanks in advance. Jeff ------------------------------------------------------------- Annual Sponsor - Figleaf Software <http://www.figleaf.com> To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- Annual Sponsor FigLeaf Software - http://www.figleaf.com To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------