Need Help and Advice

[Guest_imported]

Dear All,

I need some help regarding the following problem:

I'm inserting a record to table (Access or Sql Server) in Same Asp after submitting to it. When ever i refresh the ASP using refresh button from browser it's adding new record to the table. How can i over come this problem?.
I'm using auto counter as ID (primary key for the table).

Thanks is advance.

Sathya

 

[dds82]

What you need to do is check if the form was actually submitted, or if the ASP page is just loading for the first time. To do this, just check if one of the form elements exists:

<%
    if request.form(&quot;some_field&quot;) <> &quot;&quot; then
        ' Insert record
    end if
%>