ADO Tutorial
ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed UpADO Objects
ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypesADO Summary
ADO Examples
ADO ExamplesADO Exam
ADO CertificateADO 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
%>
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
Your suggestion:
Close [X]
Thank You For Helping Us!
Your message has been sent to W3Schools.
Close [X]
