duplication in records [modified]
-
Dear all I created a Data Entry web page (PHP) that has a form with a number of components such as name, mobile , age, etc... (text fields). These data is entered in the database. This page is used by more than one user at a time. The problem is that some records are entered twice or more in the database. There are some records was entered 15 times and all of them at the same time. I am sure that my code execute the SQL statment once only. What could be the problem? Why the script is executed more than one time? Is it a Thread issue? Is it a Server issue? My database is Oracle and the page is in PHP. regards -- modified at 2:47 Wednesday 28th November, 2007
-
Dear all I created a Data Entry web page (PHP) that has a form with a number of components such as name, mobile , age, etc... (text fields). These data is entered in the database. This page is used by more than one user at a time. The problem is that some records are entered twice or more in the database. There are some records was entered 15 times and all of them at the same time. I am sure that my code execute the SQL statment once only. What could be the problem? Why the script is executed more than one time? Is it a Thread issue? Is it a Server issue? My database is Oracle and the page is in PHP. regards -- modified at 2:47 Wednesday 28th November, 2007
hi mhmo you see, sometimes when we design our tables, we bare in mind that there might be two "john" or "Marry", so we need to identify them uniquely, we add an identity column or we look for something that will make them unique, like Social Security number, or ID number in your Country, but if you want to use that you can use IDentity column, by that you can track your problem, Another thing is that after your user submit your form that will insert data into the table, you have make sure that your user click it once. after a user click your Submit or save button once, Disable your button and display a Progress bar and you will have less Problems. Hope this Helps
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
hi mhmo you see, sometimes when we design our tables, we bare in mind that there might be two "john" or "Marry", so we need to identify them uniquely, we add an identity column or we look for something that will make them unique, like Social Security number, or ID number in your Country, but if you want to use that you can use IDentity column, by that you can track your problem, Another thing is that after your user submit your form that will insert data into the table, you have make sure that your user click it once. after a user click your Submit or save button once, Disable your button and display a Progress bar and you will have less Problems. Hope this Helps
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za
-
hi I know that. And already I have an identity column and also I am disabling the button. It seems that the problem is a Thread related or Server related. Thanks
hi Am not strong in threads, i always make sure that i dont use them, but some situations like concurency handling, or your case, you have to use them. am sorry i could not help thanks
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za