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  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   

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 - 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
-

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

2008-03-20 Thread Dusty Hale 
Probably not as graceful as the ajax approach but it will get the job done.
 
Dusty

  _  

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Howard
Sent: 03/20/2008 1:28 PM
To: discussion@acfug.org
Subject: Re: [ACFUG Discuss] looking for opinions on duplicate form
submissions


Funny, this is exactly what I said I might do while I was just at lunch.
The "wizard" version of the form where the duplicate check happens right
before the file upload.  I was still in the middle of weighing the pros and
cons eating my sandwhich and decided to check here to see if any new ideas
were posted.
 
btw,
 
thanks everyone for you help/suggestions.


On Thu, Mar 20, 2008 at 12:26 PM, Dusty Hale <[EMAIL PROTECTED]> wrote:


If you don't have time to learn ajax why not split it into several screens:
 
Screen 1
 
User fills out form clicks "Continue >>" instead of submit. Don't upload any
file on this screen though
 
Put the form data into a session var and check the db for dups.
 
Screen 2
 
Present duplicate message  offer to "continue >>" or "cancel" instead of
the save option.
 
Screen 3
 
File uploader.
 
Screen 4 
 
Thank you ... bla bla ... complete ...
 
 
Now if you check 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 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 it's up to the user to
decide if they're duplicating the work of someone else or their own.  So I
have to query the db and display to the end user which form(s) already exist
that contain the same data as theirs does and request that they review and
then 'save' or 'cancel'.
 
Is this something best suited for Ajax or is there an equally as efficient
way to accomplish this without the use of Ajax?

- 
Annual Sponsor - Figleaf  <http://www.figleaf.com/> Software 

To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
<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  <http://www.figleaf.com/> Software 

To unsubscribe from this list, manage your profile @ 
http://www.acfug.org?fa=login.edituserform
<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 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
-

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

2008-03-20 Thread Jeff Howard 
Funny, this is exactly what I said I might do while I was just at lunch.
The "wizard" version of the form where the duplicate check happens right
before the file upload.  I was still in the middle of weighing the pros and
cons eating my sandwhich and decided to check here to see if any new ideas
were posted.

btw,

thanks everyone for you help/suggestions.

On Thu, Mar 20, 2008 at 12:26 PM, Dusty Hale <[EMAIL PROTECTED]> wrote:

>  If you don't have time to learn ajax why not split it into several
> screens:
>
> Screen 1
>
> User fills out form clicks "Continue >>" instead of submit. Don't upload
> any file on this screen though
>
> Put the form data into a session var and check the db for dups.
>
> Screen 2
>
> Present duplicate message  offer to "continue >>" or "cancel" instead
> of the save option.
>
> Screen 3
>
> File uploader.
>
> Screen 4
>
> Thank you ... bla bla ... complete ...
>
>
> Now if you check 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 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 it's up to the user to
> decide if they're duplicating the work of someone else or their own.  So I
> have to query the db and display to the end user which form(s) already exist
> that contain the same data as theirs does and request that they review and
> then 'save' or 'cancel'.
>
> Is this something best suited for Ajax or is there an equally as efficient
> way to accomplish this without the use of Ajax?
>
> -
> Annual Sponsor - Figleaf Software <http://www.figleaf.com/>
>
> To unsubscribe from this list, manage your profile @
> http://www.acfug.org?fa=login.edituserform<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<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
-

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 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\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

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 - 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
-

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

2008-03-20 Thread Kitchens, Brent 
Jeff,
I've written an application that has to handle this same problem.  Here's what 
I did to solve it:


 1.  When the user submits the form, go ahead and accept the form upload on the 
server, but don't do the file upload or insert into the db yet.
 2.  After submission run a query of the db using criteria that will determine 
if more than one submission for this person has occurred.  In my case, my 
application allows only one upload from each person to a category of file 
uploads. (i.e, Bob Smith may only upload one file to the table for category A). 
 My query runs right after form submission and gets the record count where the 
criteria are true.  I use .  This could 
be done with any element of the form, but I use the user's name and the 
category.  If I get a return record count of gt 0, the user has already 
submitted for this category.  However, there's a chance they want to replace 
their submission
 3.  If my cfif evaluates as true, I write the possible duplicate to a 
temporary directory and I display a form that:
*   Tells the user they have already submitted something for this category.
*   Displays the current submission information returned from 
myduplicatequery - (the original submission)
*   Displays the new submission information.  I populate the new submission 
from the form variables submitted and use 
#cffile.serverFileName#.#serverFileExt# to display the new file they are trying 
to submit.
*   Displays 2 buttons on the form. On Submits the other doesn't.
 4.  Based on the button value chosen I:
*   Yes -  Move the file from the temporary directory to the usual 
destination directory. (Note: The file name can now be obtained from the form 
scope variable of the confirmation form as it was populated with 
#cffile.serverFileName#.#serverFileExt#.) I use cffile action=move and set 
nameconflict=overwrite as the user has chosen to replace their old file with a 
new one.  Then update the db with the new file name and any other variables 
that may have been changed from the original.  Then, display a success screen 
to the user.  I recommend using the usual error catching code to make sure the 
db write was successful.
*   No - Delete the file from the temporary directory and then display a 
screen that says the replacement was aborted.

Hope this helps.

Brent Kitchens
Emory 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 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 it's up to the user to decide if 
they're duplicating the work of someone else or their own.  So I have to query 
the db and display to the end user which form(s) already exist that contain the 
same data as theirs does and request that they review and then 'save' or 
'cancel'.

Is this something best suited for Ajax or is there an equally as efficient way 
to accomplish this without the use of Ajax?

-
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>
-


This e-mail message (including any attachments) is for the sole use of
the intended recipient(s) and may contain confidential and privileged
information. If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this message (including any attachments) is strictly
prohibited.

If you have received this message in error, please contact
the sender by reply e-mail message and destroy all copies of the
original message (including attachments).



-

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

-

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

2008-03-20 Thread Dusty Hale 
If you don't have time to learn ajax why not split it into several screens:
 
Screen 1
 
User fills out form clicks "Continue >>" instead of submit. Don't upload any
file on this screen though
 
Put the form data into a session var and check the db for dups.
 
Screen 2
 
Present duplicate message  offer to "continue >>" or "cancel" instead of
the save option.
 
Screen 3
 
File uploader.
 
Screen 4 
 
Thank you ... bla bla ... complete ...
 
 
Now if you check 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 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 it's up to the user to
decide if they're duplicating the work of someone else or their own.  So I
have to query the db and display to the end user which form(s) already exist
that contain the same data as theirs does and request that they review and
then 'save' or 'cancel'.
 
Is this something best suited for Ajax or is there an equally as efficient
way to accomplish this without the use of Ajax?

- 
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
-

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

2008-03-20 Thread Dean H. Saxe 
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: 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 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
---

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 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 11:45 AM, Jeff Howard wrote:

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 it's up  
to the user to decide if they're duplicating the work of someone  
else or their own.  So I have to query the db and display to the end  
user which form(s) already exist that contain the same data as  
theirs does and request that they review and then 'save' or 'cancel'.


Is this something best suited for Ajax or is there an equally as  
efficient way to accomplish this without the use of Ajax?


-
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
-

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 it's up to the user to
decide if they're duplicating the work of someone else or their own.  So I
have to query the db and display to the end user which form(s) already exist
that contain the same data as theirs does and request that they review and
then 'save' or 'cancel'.

Is this something best suited for Ajax or is there an equally as efficient
way to accomplish this without the use of Ajax?



-
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
-

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

2008-03-20 Thread Fennell, Mark P. 
Another thought... I don't know about Windows, but on *nix machines you
could use diff to compare files and if they are identical, just toss
one. Assuming you know which files to compare... 



From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dean H. 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 surfing habits to target advertising.  I enable scripting on a
whitelist of trusted sites only. 

-dhs



Dean H. Saxe, CISSP, CEH
[EMAIL PROTECTED]
"Great spirits have often encountered violent opposition from weak
minds." 
--Einstein


On Mar 20, 2008, at 11:10 AM, Douglas Knudsen wrote:


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 from that, maybe some sort of random key deal that you
could test server side, if the key is inprocess, do nothing, ow process.
But the upload issue might still be there as this occurs before your CFM
processing does.  I might re-factor the UI putting  document uploads on
a separate view from the data input.

hope the rambling helps... :)


DK


On Thu, Mar 20, 2008 at 10:51 AM, Jeff Howard <[EMAIL PROTECTED]>
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\n
eotmp13963.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>  

- 




-- 
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it? 
- 
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

-

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

2008-03-20 Thread axunderwood 
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: 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
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\n
eotmp13963.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
<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/>  

--

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
is where i ran into the issue with the attachments now having the temp
directory path and CF not being able to find them.

I might look into the myAjax solution but am open for any and all
suggestions.  I'd really like to get my Ajax skills elevated but this
project is some what time sensitive.

Thanks agian for the help and suggestions.



-
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
-

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 but, you can weigh the cost of that decision.
-Steven

On Thu, Mar 20, 2008 at 11:10 AM, Douglas Knudsen <[EMAIL PROTECTED]>
wrote:

> 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 from that, maybe some sort of random key deal that you could test
> server side, if the key is inprocess, do nothing, ow process.  But the
> upload issue might still be there as this occurs before your CFM processing
> does.  I might re-factor the UI putting  document uploads on a separate view
> from the data input.
>
> hope the rambling helps... :)
>
>
> DK
>
>
> On Thu, Mar 20, 2008 at 10:51 AM, Jeff Howard <[EMAIL PROTECTED]> 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 
> > -
>
>
>
>
> --
> Douglas Knudsen
> http://www.cubicleman.com
> this is my signature, like it?
> -
> 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 
> -
>



-- 
Steven Ross
web application & interface developer
http://blog.stevensross.com
[mobile] 404-488-4364 [fax] 267-482-4364
[ AIM / Yahoo! : zeriumsteven ] [googleTalk : nowhiding ]



-
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
-

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
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 - 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
-

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."
--Thomas Jefferson



On Mar 20, 2008, at 11:12 AM, Kevin Hellriegel wrote:

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  
settings in mxAjax and then you can call it via javascript. There  
are some good docs on there and if you choose to go with it, I can  
help you out.


Kevin

On Thu, Mar 20, 2008 at 10:51 AM, Jeff Howard <[EMAIL PROTECTED]>  
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
-

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"
3. Use the CFID or  jsessionid as the name of the uploaded file and
allow files to be overwritten. nameconflict="OVERWRITE"
mf
 
 
mark fennell
athens regional medical center
athens, ga
 



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\n
eotmp13963.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 - 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

-

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 PROTECTED]
"Great spirits have often encountered violent opposition from weak  
minds."

--Einstein


On Mar 20, 2008, at 11:10 AM, Douglas Knudsen wrote:

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 from that, maybe some sort of random  
key deal that you could test server side, if the key is inprocess,  
do nothing, ow process.  But the upload issue might still be there  
as this occurs before your CFM processing does.  I might re-factor  
the UI putting  document uploads on a separate view from the data  
input.


hope the rambling helps... :)


DK

On Thu, Mar 20, 2008 at 10:51 AM, Jeff Howard <[EMAIL PROTECTED]>  
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
-



--
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?
-
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
-

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 settings in mxAjax and then you can call it via
javascript. There are some good docs on there and if you choose to go with
it, I can help you out.

Kevin

On Thu, Mar 20, 2008 at 10:51 AM, Jeff Howard <[EMAIL PROTECTED]> 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 - 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
-

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 from
that, maybe some sort of random key deal that you could test server side, if
the key is inprocess, do nothing, ow process.  But the upload issue might
still be there as this occurs before your CFM processing does.  I might
re-factor the UI putting  document uploads on a separate view from the data
input.

hope the rambling helps... :)


DK

On Thu, Mar 20, 2008 at 10:51 AM, Jeff Howard <[EMAIL PROTECTED]> 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 
> -




-- 
Douglas Knudsen
http://www.cubicleman.com
this is my signature, like it?



-
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
-

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 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
-