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]
