ADO Direction Property

❮ Complete Parameter Object Reference

The Direction property sets or returns a ParameterDirectionEnum value that specifies how a parameter is passed to or from a procedure. Default value is adParamInput.

Is it an input parameter, an output parameter, an input and an output parameter, or a return value from a procedure?

Syntax

objparameter.Direction

Example

<%
set comm=Server.CreateObject("ADODB.Command")
set para=Server.CreateObject("ADODB.Parameter")

para.Type=adVarChar
para.Size=25
para.Direction=adParamInput
para.Value=varfname

comm.Parameters.Append para
%>

ParameterDirectionEnum Values

Constant	Value	Description
adParamUnknown	0	Direction unknown
adParamInput	1	Default. Input parameter
adParamInputOutput	3	Input and output parameter
adParamOutput	2	Output parameter
adParamReturnValue	4	Return value

❮ Complete Parameter Object Reference