inserting data into database 1

[peter11]

I am using a form to insert names in to a database. The problem occurs when the user enters the name and while they are on the action page they hit the refresh button.
The data gets inserted again and I end up with duplicate names.

Is there a way to prevent this from happening?

 

[Sarky78]

What i tend to do is to have an action page that is invisible to the user so that all of the code is processed and then when it is all done move onto another page, using CFLOCATION

So you would have your form page (page1) that submits to the action page (page2) which then transfers to another page confirming what has happened. The user can refresh this page all they like the data will only be inserted by the previous page !

hope this helps !

 

[webron]

Maybe you could check on duplicate entries
Query checkdupe checks for duplicates
If 'checkdupe' return a record -> update the record (or do nothing, whatever you want). Else insert the record.

<cfquery name=&quot;checkdupe&quot; datasource=&quot;datasource&quot;>
select fieldname
from table
where fieldname = '#form.name#'
</cfquery>

<cfif checkdupe>
.. update query, do nothing
<cfelse>
.. insert query
</cfif>