|
jkalkow -> Comparing data from two tables (9/11/2005 22:29:58)
|
Simple Q: Using DRW, I would like to have a page that can compare two tables and notify me of a match.
Deeper explaination: I add about 15,000 records to my database once a week. The records go into TABLE A. TABLE A contains a combined last name/first name column, birth date, address, phone number, etc. TABLE B is a table that contains a combined last name/ first name column and a birth date. That database has about 300 names in it. What I would like to do is be able to automatically bring up an ASP page, created with DRW, that will simply list a row when there is a match. Once I determine there is no match, TABLE A is deleted and I import my list again next week.
I have created simple pages where a variable is passed to the results page (i.e. ::name::, ::dob::) but I do not know how to use my "query source" from a SQL table.
Thanks,
Jim
|
|
|
|
