Latest web development tutorials
 

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