Uhm, if its the same data, take a hash of every entered form/file.
Then see if you can find a duplicate of the hash in your stored data.
Problem solved.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"What is objectionable, what is dangerous about extremists is not that
they are extreme, but that they are intolerant."
-- Robert F. Kennedy, 1964
On Mar 20, 2008, at 11:35 AM, <[EMAIL PROTECTED]>
<[EMAIL PROTECTED]> wrote:
Ok...that is a tougher one....
One suggestion is this (high level)... if your database table isn't
too large and is indexed properly, you might consider having
something like this:
On the top of your form (or somewhere that will be visible at all
times), have a summary box that updates as you enter information
into each field. So, for instance, if you have first name, last
name, and city on a form, after you exit the first name field (it
loses focus), you could run a query behind the scenes to find out
how many entries are in the table with a combination of filled out
fields. As a user finishes up the form, the summary box may show
that their are currently 2 entries that are similar to the one
entered on the form and give 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: [email protected]
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 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 if they're identical I'm displaying a
message saying something to the effect of "check these and make sure
you're not duplicating someone's work". If after comparing, they
decide that it's not a duplicate they hit ok and it commits.
The trick here, is that all the form data can be identical and
something in the attachments could be different, so the user has to
look at the previous entries to decide if it's a duplicate or not
and then click 'save' or 'cancel'.
On Thu, Mar 20, 2008 at 11:03 AM, Dean H. Saxe <[EMAIL PROTECTED]
> wrote:
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 its a duplicate or out of order submission.
-dhs
Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"Free speech exercised both individually and through a free press,
is a necessity in any country where people are themselves free."
-- Theodore Roosevelt, 1918
On Mar 20, 2008, at 10:51 AM, Jeff Howard wrote:
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\neotmp13963.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
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
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor - Figleaf Software
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
-------------------------------------------------------------
-------------------------------------------------------------
Annual Sponsor - Figleaf Software
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
-------------------------------------------------------------
