duplicate entry in database
We are recieving a duplicating entry when we submit this form: member_directory_Insert.php
need more details.
I have filled out your form a few times and got a few different errors ranging from Incorrect date time value: '12/2/2009' for column 'MDateOfEntry' to Data to long for column M1.
When you get the error "duplicate entry in database" it means you are trying to store a value that already exists in a column that has been set to not allow duplicates. most time it will happen if you are trying to set a value on the primary key column. review your database structure for columns that do not allow duplicates. Also double check the insert record behavior to make sure a value is not being set for the primary key column.
You can just fill out the first name and last name for testing purposes and then click the "Insert" button at the bottom of the page.
I'm not getting the errror "duplicate entry in database", I am just getting 2 of the exact listing in their when I click the "Insert" button once.
Thanks for your help! Let me know if you have any additional questions.
you need to create a recordset to see if the data being entered already exists. I would expect you wish to check for the first name last name combo, set the recordset to filter the first name, last name columns on the respective form elements.
next add sserver validation, use Number validation, set the variable to:
where <Recordset Name>is the name of your recordset.
set the minimum number to -1 and the Maximum to 0
This will cause validation to pass only if the recordset is empty.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.