validate database

[Monie]

i have declared 3 primary key in my database,
i have a form, that will ask the user to input this three data,
i have used <on error resume next> function in my page. if there is a duplication or an error in the submitted page, it will open an error page which i had created.

the problem is, i have set that in the form, when the user click the submit button, the page will redirect to the display page, even if the page contain an error(duplication in database)
that means that the on error resume next is not working..

anybody can help me please?

[Rob]

Hi Monie....

The USUAL way to deal with this sort of thing is to have the form post to the same ASP page.

If you give a name and a value to your submit button, then you can check if request.form("buttonname") has a value.... if it has the form was submitted... if not, then the form needs to be displayed. Does that make sense? here is some pseudo code:-

Code: Select all

If request.form("buttonname") <> "" then
    'form was submitted
    'error checking code goes here.
    If anErrorOccured then 
       ShowForm = True
    else
       'Entered info was ok
       'code to update database, etc, etc
    end if
else
    ShowForm = True
end if
If showform then
     'code to show the form
end if

Hope this helps.

[Monie]

well rob...
if i give you a look of my code, will you willing to show me how to code them.
i am having trouble doing the if-else statement in my page especially if it deals with the database connection!

i'll post you soon
thanx for the idea

[Monie]

Well...actually i have solve that problem.

I have post the form to the same page but i have included the display page under the form so that the user can know that their request have been stored and accepted by the database.

Thanx rob.