Hi All,

I'm having some difficulty calling a sproc and returning a value. My MM app method code is

/// <summary>
		/// Returns a classname (string) from the passed classid (int) parameter
		/// </summary>
		public string GetClassName(int key) 
		{
			// Get a reference to the data access object
			mmDataAccessBase dao = this.GetDataAccessObject();

			// Create the parameters and set the direction
			IDbDataParameter param1 = dao.CreateParameter("@ClassID", key);
			param1.Direction = ParameterDirection.Input;
			
			string classname = "trysomejunktexthere";

			IDbDataParameter param2 = dao.CreateParameter("@ClassName",classname);
			param2.Direction = ParameterDirection.Output;

			// Call the stored procedure and pass the parameters
			IDbCommand cmd;			
			this.ExecSprocScalar("ssAPI_getClassName",out cmd, param1, param2); 

			// Retrieve the value from the command object
			IDbDataParameter param = (IDbDataParameter)cmd.Parameters["@ClassName"];
			string retval = param.Value.ToString();

			return retval;
		}