I have the following ASP and Stored Proc.
I have one input that is hard coded for now - 1000 and I want to return
3 values... Nothing comes back at all - not even an error.

ASP

<%
dim company, created, expires
		 cmd.activeconnection = conn
		 cmd.commandtext = "sp_getco_info"
		 cmd.commandtype = adcmdstoredproc

		 'input
		 cmd.Parameters.Append cmd.CreateParameter("@client_id",
adInteger, adParamInput, 3)
		 cmd.Parameters("@client_id").value = 1000

		 'output
		 cmd.Parameters.Append cmd.CreateParameter("@company",
adVarChar, adParamReturnValue, 200)
		 cmd.Parameters.Append cmd.CreateParameter("@created",
adDBTimeStamp, adParamReturnValue)
		 cmd.Parameters.Append cmd.CreateParameter("@expires",
adDBTimeStamp, adParamReturnValue)
		 set rs = cmd.Execute

response.write cmd.Parameters("@company").value
response.write cmd.Parameters("@created").value
response.write cmd.Parameters("@expires").value
 
%>

---- Stored Proc------


alter PROCEDURE sp_getco_info

@client_id	int,
@company	varchar(128) OUTPUT,
@created	datetime OUTPUT,
@expires	datetime OUTPUT
	
AS
SET NOCOUNT ON

select company=@company, created=@created, expires=@expires 
from tbl_news_client 
where client_id=@client_id

SET NOCOUNT OFF

GO



Any help would be great!
Thanks!
Aaron

a) http://www.adopenstatic.com/faq/SprocsAndParameters.asp
will tell you where you need to append the return parameter

b) You can only have one return parameter. Usually return parameters are
used to accept the *return* value from an SQL Server sproc. The Return value
is 0 by default, and usually indicates that no error occured. Otherwise, the
return value holds the error number that is raised by SQL Server.

I think what you want are *output* parameters. These are usually used to
hold values that you want to extract from the database (adParamOutput, not
adParamReturnValue)

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "aaron" <agflem@y...>
Subject: [asp_database_setup] adParamReturnValue


: I have the following ASP and Stored Proc.
: I have one input that is hard coded for now - 1000 and I want to return
: 3 values... Nothing comes back at all - not even an error.
:
: ASP
:
: <%
: dim company, created, expires
: cmd.activeconnection = conn
: cmd.commandtext = "sp_getco_info"
: cmd.commandtype = adcmdstoredproc
:
: 'input
: cmd.Parameters.Append cmd.CreateParameter("@client_id",
: adInteger, adParamInput, 3)
: cmd.Parameters("@client_id").value = 1000
:
: 'output
: cmd.Parameters.Append cmd.CreateParameter("@company",
: adVarChar, adParamReturnValue, 200)
: cmd.Parameters.Append cmd.CreateParameter("@created",
: adDBTimeStamp, adParamReturnValue)
: cmd.Parameters.Append cmd.CreateParameter("@expires",
: adDBTimeStamp, adParamReturnValue)
: set rs = cmd.Execute
:
: response.write cmd.Parameters("@company").value
: response.write cmd.Parameters("@created").value
: response.write cmd.Parameters("@expires").value
:
: %>
:
: ---- Stored Proc------
:
:
: alter PROCEDURE sp_getco_info
:
: @client_id int,
: @company varchar(128) OUTPUT,
: @created datetime OUTPUT,
: @expires datetime OUTPUT
:
: AS
: SET NOCOUNT ON
:
: select company=@company, created=@created, expires=@expires
: from tbl_news_client
: where client_id=@client_id
:
: SET NOCOUNT OFF
:
: GO
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~