if it already exists then someone has refreshed/resubmitted the poll
and to ignore that entry.
On Wed, 22 Sep 2004 12:08:50 -0400, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> I'm not really following.
> The form has a hidden field with the primary key of the poll. I use
> that to determine whether the poll was answered. Are you suggesting
> making a primary key just for the form itself, nothing to do with the
> db otherwise?
>
> They should be able to submit multiple times, just not on refresh.
>
> >Are you using a pkey?
> >You could generate this pKey on the form page and then on the form
> >action page check to see if it exists..
> >
> ><query name="chkDB">
> >select * from table where pkey_column = #value#
> ></query>
> ><cfif chkDB.recordcount gte 1>
> >This record already exists
> ><cfelse>
> >preform insert
> ></cfif>
> >
> >so the first time it would insert, everytime after that it wouldn't
> >store that value in a session variable and you shouldnt have to
> >worry about it..
> >however if you wanted them to be able to submit multiple time (new
> >forms) then you'd want to clear out that value and get a new one for
> >it.
> >
> >On Wed, 22 Sep 2004 11:00:41 -0400, Daniel Kessler <[EMAIL PROTECTED]> wrote:
> >> I have a form that goes to a page which updates a database. I check
> >> to see if the form exists and that an answer exists so that the
> >> database will be updated. Unfortunately, when I refresh the page, it
> >> re-submits the form content. I tried setting up a no-cache pragma
> >> <META HTTP-EQUIV="Pragma" CONTENT="no-cache">
> >> <META HTTP-EQUIV="Expires" CONTENT="-1">
> >>
> >> as well as:
> >> document.forms[0].reset(); which only applies to the form
> >>elements, it seems.
> >>
> >> Still, when I refresh the page, I resubmit the content. Anyone know
> > > a cure for this, either through CF or not?
> >>
>
> --
> Daniel Kessler
>
> Department of Public and Community Health
> University of Maryland
> Suite 2387 Valley Drive
> College Park, MD 20742-2611
> 301-405-2545 Phone
> www.phi.umd.edu
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
