Whats the syntax for retrieving a form parm and then calling a SQL stored proc, passing it the parm?

In the example below, i am getting the parm PRODUCTID and want to pass it to a stored procedure called "SP_SelectProductsByID".

-----------

Set myConnection = Server.CreateObject("ADODB.Connection")
Set rsTitleList = Server.CreateObject("ADODB.Recordset")
myConnection.Open connectString
requestID = Request.Form("ProductID")
Set RSTitleList = myConnection.Execute(SP_SelectProductsByID ?RequestID)