problem with output parameter of type 'uniqueidentifier' in a stored procedure

<i><b>Originally posted by : lyubomir (lubomir@ou.edu)</b></i><br /><br />hey all,<br /> i am having problems getting data from a database using ADO.<br />here is the part of the code that does not work:<br /><br /> If Request.QueryString("id") <> "" Then CME_ID =<br />Request.QueryString("id") Else CME_ID = 0<br /> If Request.Form("quizName") <> Null Then Title = Request.Form("quizName")<br />Else Title = "me"<br /> If Request.Form("NumberOfQuestions") <> "" Then NumberOfQuestions =<br />Request.Form("NumberOfQuestions") Else NumberOfQuestions = 0<br />'**********************************End************ **************************<br />**************************************<br /><br />'************************************************* **************************<br />**************************************<br />' Open Stored Procedure usp_Docsynergy_CME_Quiz_InsertNewQuiz<br />*<br />'************************************************* **************************<br />**************************************<br />set cmdAddNewQuiz = Server.CreateObject("ADODB.Command")<br />cmdAddNewQuiz.ActiveConnection = ConnectID<br />cmdAddNewQuiz.CommandText = "dbo.usp_Docsynergy_CME_Quiz_InsertNewQuiz"<br />cmdAddNewQuiz.Parameters.Append<br />cmdAddNewQuiz.CreateParameter("@RETURN_VALUE", 3, 4)<br />cmdAddNewQuiz.Parameters.Append cmdAddNewQuiz.CreateParameter("@intCME_ID",<br />3, 1, 4, CME_ID)<br />cmdAddNewQuiz.Parameters.Append<br />cmdAddNewQuiz.CreateParameter("@intCreatorUserCode", 3, 1, 4,<br />CreatorUserCode)<br />cmdAddNewQuiz.Parameters.Append cmdAddNewQuiz.CreateParameter("@strTitle",<br />200, 1, 100, Title)<br />cmdAddNewQuiz.Parameters.Append cmdAddNewQuiz.CreateParameter("@uidQuizID",<br />72, 2)<br />cmdAddNewQuiz.CommandType = 4<br />cmdAddNewQuiz.CommandTimeout = 0<br />cmdAddNewQuiz.Prepared = true<br />set rsQuizInfo = cmdAddNewQuiz.Execute()<br />rsQuizInfo_numRows = 0<br /><br />QuizID = cmdAddNewQuiz.Parameters.Item("@uidQuizID").Value<br />response.write(QuizID)<br />response.end<br /><br />the problem is that after execution, the value of variable 'QuizID' is<br />nothing, i.e. it does not display anything on the screen, while it should,<br />because the table in the database that corresponds to that stored procedure<br />is not empty, i looked at it. any ideas what could be wrong?<br />thanks!<br />