Is there a way to create a recordset with tables from two databases. I'm using Dreamweaver, asp pages with VBScript. The databases are SQL Server 2000. I Have no idea where to start with this one. Anyone have any ideas?

I'm pretty sure that's beyond DW's default capabilities. The basic way is setup two <i>Connections</i> and each <i>Recordset</i> can only pull from one <i>Connection</i>, meaning one DB. But multiple <i>Recordsets</i> can then be filtered and parsed or joined or whatever.

There's a company <i>Advanced Extensions</i> (www.AdvancedExtensions.com) who makes a DW extension for advanced SQL queries. They talked about a multi-database feature but I read somewhere that their parent company is the one who makes that type of stuff, so try to hunt from there a little.

~ ~ ~ ~ ~ ~ ~
Chris Charlton <i>- DMXzone Manager</i>
<font size=1>[ Studio MX/MX2004 | PHP/ASP | SQL | XHTML/CSS | XML | Actionscript | Web Accessibility | MX Extensibility ]</font id=size1>