|
| |
|
|
jkalkow
Posts: 39
Joined: 8/6/2004
From: Connecticut
Status: offline
 |
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
|
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
