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
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
|