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

Whether you're new to XML or already an advanced user,
the user-friendly views and powerful entry helpers,
wizards, and debuggers in XMLSpy are designed to meet your XML
and Web development needs from start to finish.
New features in Version 2010!
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- XBRL validator, taxonomy editor, taxonomy wizard
- Support for Office Open XML (OOXML)
- Graphical WSDL 1.1/2.0 editor & SOAP debugger
- JSON editing & conversion
- Java, C#, C++ code generation
- And much more!
Download a free trial today!
|
|
|
|