multiple databases one recordset

[thompom]

Hi,

I need to do a customer search from at least 3 different databases on different connections/servers.

I would like to create one recordset and then output the results - as this isnt possible, i would need mutiple recordsets and then to merge the results in one loop - how would I do this - is XML an idea?

thanks MG

 

[thompom]

in case anyones interested - founda great func

http://forums.aspfree.com/code-bank...-recordsets-into-single-recordset-169622.html