Need help to find a solution for this problem
-
Hi, Let me explain step by step, First: I have a file which gives details of a user as., FName, MName, LName, Address, TestDate, TestResult etc... Second: I have to import this file and store it in Data Base. And assiagn a unique number to each user. I am maintaining a Database where candidate details and test details are stored in separate tables using the unique id i created as the key. Third: If this user to whom i had already assaigned a unique number, will take another test. And again the data is send in the same format (FName, MName, LName, Address, TestDate, TestResult etc...). Forth: This file does not have any number or a unique field which can differentiate one user with other. Fifth: In this case i have to only input the test details and not the candidate details as the user is already holding a unique id. Question 1: How can i differentiate the users from one to another. Question 2: How can i check wheather the user candidate data is already in the database or not. As generally different users do have same name and common addresses which are very irrelavent to check.
Jats
modified on Friday, January 18, 2008 6:50:00 AM
-
Hi, Let me explain step by step, First: I have a file which gives details of a user as., FName, MName, LName, Address, TestDate, TestResult etc... Second: I have to import this file and store it in Data Base. And assiagn a unique number to each user. I am maintaining a Database where candidate details and test details are stored in separate tables using the unique id i created as the key. Third: If this user to whom i had already assaigned a unique number, will take another test. And again the data is send in the same format (FName, MName, LName, Address, TestDate, TestResult etc...). Forth: This file does not have any number or a unique field which can differentiate one user with other. Fifth: In this case i have to only input the test details and not the candidate details as the user is already holding a unique id. Question 1: How can i differentiate the users from one to another. Question 2: How can i check wheather the user candidate data is already in the database or not. As generally different users do have same name and common addresses which are very irrelavent to check.
Jats
modified on Friday, January 18, 2008 6:50:00 AM
Jats_4ru wrote:
As generally different users do have same name and common addresses which are very irrelavent to check.
If different users really have the same name and the same address, then you don't have enough information to determine if a user already exists in the database or not.
Experience is the sum of all the mistakes you have done.