Validation causes duplicate insert

I am having a problem where applying the validation toolkit is causing my standard dreamweaver insert behaviour to produce a duplicate record.

If I remove the validation toolkit from the form the form submit then it submits and inserts only a single record as expected.

I have cut the validation down to a single field length requirement on form submit, but still having no joy.

I have attached a copy of the .asp (with .txt extension to allow upload) file.

Can you please advise

Thanks

Andy

It doesn't look like the attachment worked. Make sure that the insert server behavior is not called before the validation code goes through. If the insert server behavior is before the validation code, at the top of the page, then it will insert and then the validation code will run and forward to the page and may be inserting again.

Could you see the code I attached, if you could point me to where the validation code begins or what it looks like I'll happily move it, just not sure what to look for and move to.

Any pointers would be great!

Thanks

Andy

I don't see an attachment still. Could you try attaching it again? Make sure its a valid attachment file extension.

I have re-added the attachment for you to review.

Thanks again for your help.

A

It appears that you have applied the validations to fire on the on click of the button. This doesn't prevent the form from being submitted, so the form will still submit with the incorrect values. If you change the validations to the onSubmit of the form, then the validation and insert should work correctly.

Basically on line 1363 of the form, you have onClick="<validation code>". You want to copy the <validation code> and put it in the onSubmit of the form on line 729.

Hi thanks for the response, i have tried your suggestion and re-uploaded modified page.

Still getting duplicate insert. Can you help please, i am so near to completing this page and this is my final issue.

Many thanks

A

That looks correct. Do you have a page where we can view it live and test for ourselves? Have you looked in the error console to be sure there are no javascript errors? I think I would start with that.

Sorry I dont have a live server, I have looked all over but cannot stop this from occurring is there anything else you can do to help me on this as I'm really struggling.

Thanks

Andy

I can supply a copy of any page required as well as a copy of the DB if needed, just dont have a website i can direct you to currently.

can you please suggest how I can solve this issue...

Thanks

Andy