I am having problems with a stored procedure and trying to return values from it. I can get it to return a recordset ok, but I would also like to return a single value along with that recordset. Something like this....<BR><BR>Create procedure sp_crap<BR><BR>@ID int,<BR>@title varchar(30) OUTPUT<BR> <BR>AS<BR>SET NOCOUNT ON<BR>--get user title<BR>Select @title = user_title From users where user_id = @int<BR>Select * from user_history where user_id = @int<BR><BR>------------------------------------<BR>Now I try to call it in ASP, I just get a blank for @title<BR>Set strCommand = Server.CreateObject("ADODB.Command")<BR>strCommand .ActiveConnection = connectme<BR>strCommand.CommandText = "sp_crap"<BR>strCommand.CommandType = adCmdStoredProc<BR>strcommand.Parameters.Refresh<B R>strCommand("@ID") = request.form("user_num")<BR>strCommand.CreateParam eter("@title",adVarChar,adParamOutput)<BR>Set RStemp = strCommand.Execute<BR>&#039try to view it..<BR>Response.Write(strCommand("@title"))<BR>&# 039I do not get anything?<BR>&#039The recordset works great.<BR><BR>Any help would be great!<BR>DRUG_DEALER<BR><BR><BR>