There's one thing that can burn you with that, though, and it seems worth mentioning -- multiple recordsets require multiple roundtrips to the server. This may or may not be an issue depending on various factors.
>use the NextRecordset method of the Recordset Object.... You will need to cycle through the first two. By default, you will already have access to the first one.
>
>ors = ors.nextrecordsets && gets you the 2nd one.
>ors = ors.nextrecordsets && gets you the 3rd one.
>
>
>HTH
The whole problem with the world is that fools and fanatics are always so certain of themselves, but wiser people so full of doubts. - Bertrand Russell