Multiply Recordsets

Hi,

Pretty new to the asp stuff but have tried two projects now and on both occasions I'm falling at the same hurdle. Multiple recordsets. The page will load but will only display the first recordset. If you go back and go to the page again the second resultset's results will be there. Both recordsets are calling stored procedures.

It seems to me that the page is executing before the second recordset has it's results. Does everyone make this mistake. How do i get round it? Is there a way of stopping the page executing untill all recordsets have run?
The DB is on SQL 2000 server and i'm using dreamweaver mx and vbscript.


Here are the recordsets,
<%

set ClientDetail = Server.CreateObject("ADODB.Command")
ClientDetail.ActiveConnection = MM_ClientLog_STRING
ClientDetail.CommandText = "dbo.SP_ClientDetail"
ClientDetail.Parameters.Append ClientDetail.CreateParameter("@RETURN_VALUE", 3, 4)
ClientDetail.Parameters.Append ClientDetail.CreateParameter("@client", 129, 1,20,ClientDetail__client)
ClientDetail.CommandType = 4
ClientDetail.CommandTimeout = 0
ClientDetail.Prepared = true
set CDetail = ClientDetail.Execute
CDetail_numRows = 0

set WS = Server.CreateObject("ADODB.Command")
WS.ActiveConnection = MM_ClientLog_STRING
WS.CommandText = "dbo.SP_ClientWS"
WS.Parameters.Append WS.CreateParameter("@RETURN_VALUE", 3, 4)
WS.Parameters.Append WS.CreateParameter("@clientid", 3, 1,4,WS__clientid)
WS.CommandType = 4
WS.CommandTimeout = 0
WS.Prepared = true
set WSSerials = WS.Execute
WSSerials_numRows = 0

%>


Many thanks in advance for you help.