Can 2 recordsets be joined or searched?

sniffer · October 20th, 2004, 10:00 AM

I have 2 recordsets loaded into an ASP page..

1st is called "rs_special" which contains 1 field called "Email_Address"
The second recordset is called "rs_A55report", which contains lots of fields but one field is called "Email"

I need to display all the records in rs_A55report on my page but only the records where "Email" is also in "Email_Address" of the other recordset...

Can anyone help? i cna't join the tables in SQL as they are seperate databases unless this can be done? thanks

happygv · October 20th, 2004, 10:55 AM

What is the Database server that you use? Is that SQL server or MS access?

_________________________
- Vijay G
Strive for Perfection

sniffer · October 20th, 2004, 11:01 AM

Its MS Access

happygv · October 20th, 2004, 11:22 AM

Then you might have to have two Loops that parse through the entire recordset (both rs_special and rs_A55report)

Code:

While NOT rs_A55report.EOF
    While NOT rs_special.EOF
        If rs_A55report("Email")= rs_special("Email_Address") then
            'Display the data from rs_A55report
        End If
        rs_special.MoveNext
    Loop
    rs_A55report.MoveNext
Loop

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection