met_comm_createparameter.asp

W3Schools tutorial..web designing

  <td>17</td>
  <td width="55%">A 1-byte unsigned integer.</td>
</tr>
<tr>
  <td>adUnsignedSmallInt</td>
  <td>18</td>
  <td>A 2-byte unsigned integer.</td>
</tr>
<tr>
  <td>adUnsignedInt</td>
  <td>19</td>
  <td width="55%">A 4-byte unsigned integer.</td>
</tr>
<tr>
  <td>adBigInt</td>
  <td>20</td>
  <td>An 8-byte signed integer.</td>
</tr>
<tr>
  <td>adUnsignedBigInt</td>
  <td>21</td>
  <td width="55%">An 8-byte unsigned integer.</td>
</tr>
<tr>
  <td>adFileTime</td>
  <td>64</td>
  <td width="55%">The number of
    100-nanosecond intervals since January 1,1601</td>
</tr>
<tr>
  <td>adGUID</td>
  <td>72</td>
  <td width="55%">A globally unique identifier (GUID)</td>
</tr>
<tr valign="top">
  <td>adBinary</td>
  <td>128</td>
  <td>A binary value.</td>
</tr>
<tr valign="top">
  <td>adChar</td>
  <td>129</td>
  <td width="55%">A string value.</td>
</tr>
<tr>
  <td>adWChar</td>
  <td>130</td>
  <td width="55%">A null-terminated Unicode character string.</td>
</tr>
<tr>
  <td>adNumeric</td>
  <td>131</td>
  <td width="55%">An exact numeric value with a fixed precision and
    scale.</td>
</tr>
<tr>
  <td>adUserDefined</td>
  <td>132</td>
  <td width="55%">A user-defined variable.</td>
</tr>
<tr valign="top">
  <td>adDBDate</td>
  <td>133</td>
  <td width="55%">A date value (yyyymmdd).</td>
</tr>
<tr valign="top">
  <td>adDBTime</td>
  <td>134</td>
  <td width="55%">A time value (hhmmss).</td>
</tr>
<tr valign="top">
  <td>adDBTimeStamp</td>
  <td>135</td>
  <td width="55%">A date/time stamp (yyyymmddhhmmss plus a fraction in
    billionths).</td>
</tr>
<tr>
  <td>adChapter</td>
  <td>136</td>
  <td width="55%">A 4-byte chapter value that identifies rows in a
    child rowset</td>
</tr>
<tr>
  <td>adPropVariant</td>
  <td>138</td>
  <td width="55%">An Automation PROPVARIANT.</td>
</tr>
<tr>
  <td>adVarNumeric</td>
  <td>139</td>
  <td width="55%">A numeric value (<b>Parameter</b> object only).</td>
</tr>
<tr>
  <td>adVarChar</td>
  <td>200</td>
  <td width="55%">A string value (<b>Parameter</b> object only).</td>
</tr>
<tr>
  <td>adLongVarChar</td>
  <td>201</td>
  <td width="55%">A long string value.</td>
</tr>
<tr>
  <td>adVarWChar</td>
  <td>202</td>
  <td width="55%">A null-terminated Unicode character string.</td>
</tr>
<tr valign="top">
  <td>adLongVarWChar</td>
  <td>203</td>
  <td width="55%">A long null-terminated Unicode string value.</td>
</tr>
<tr valign="top">
  <td>adVarBinary</td>
  <td>204</td>
  <td width="55%">A binary value (<b>Parameter</b> object only).</td>
</tr>
<tr>
  <td>adLongVarBinary</td>
  <td>205</td>
  <td width="55%">A long binary value.</td>
</tr>
<tr>
  <td>AdArray</td>
  <td>0x2000</td>
  <td>A flag value combined with another data type constant. Indicates an array of that other data type.</td>
</tr>
</table>
<h3>
<a name="parameterdirenum">ParameterDirectionEnum Values</h3>
</a>
<p>Specifies whether the Parameter represents an input parameter, an output parameter, both an input and an output parameter, or the return value from a stored procedure.</p>
<table class="ex" cellspacing="0" border="1" width="100%" cellpadding="3">
<tr valign="top">
  <th width="30%">Constant</th>
  <th width="10%">Value</th>
  <th width="60%">Description</th>
</tr>
<tr>
  <td>
adParamUnknown</td>
  <td>0</td>
  <td width="55%">Direction is unknown</td>
</tr>
<tr>
  <td>
adParamInput</td>
  <td>1</td>
  <td width="55%"> Input parameter</td>
</tr>
<tr>
  <td>
adParamOutput</td>
  <td>2</td>
  <td width="55%"> Output parameter</td>
</tr>
<tr>
  <td>
adParamInputOutput</td>
  <td>3</td>
  <td width="55%"> Both input and output parameter</td>
</tr>
<tr>
  <td>
adParamReturnValue</td>
  <td>4</td>
  <td width="55%"> Return value</td>
</tr>
</table>
<br />
<hr />
<a href="ado_ref_command.asp"><img class="navup" src="../images/up.gif" alt="Command Object Reference" border="0" /> Complete Command Object Reference</a>

<br />
<hr />

<!-- **** SPOTLIGHTS 1 **** -->

<iframe src="../banners/aspallframe.asp" height="110" width="485"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
Your browser does not support inline frames or is currently configured not to display inline frames.
</iframe>
<hr />
<!-- **** SPOTLIGHTS 2 **** -->

<h2>Want To Be A Web Master?</h2>
<p>If you want to be a Web Master, you will have to host your web site with an ISP (Internet Service Provider).</p>
<p>MaximumASP offers seven different configurations of dedicated servers to meet your Windows and .NET hosting needs.
Hosted on our multi-tiered Enterprise Class network, these servers provide the performance, security and reliability
you need to host your high end web sites and applications. 
</p>
<p><a target="_blank" href="../../www.maximumasp.com/about/specials.aspx">Visit MaximumASP</a></p>
<hr />


<!-- **** SPOTLIGHTS 3 **** -->
<table cellpadding="0" cellspacing="0"><tr><td width="72"></td><td>
<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*txt*/
google_ad_slot = "1699448869";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
</td></tr></table>
<hr />

<center>

<script type="text/javascript"><!--
google_ad_client = "pub-3440800076797949";
/*imgtxt*/
google_ad_slot = "8606855891";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="../../pagead2.googlesyndication.com/pagead/show_ads.js">
</script>

</center>
<hr />


<!-- **** END SPOTLIGHTS **** -->

</td></tr>

<tr><td>
<p>Jump to: <a href="#top" target="_top"><b>Top of Page</b></a>
or <a href="../default.asp" target="_top"><b>HOME</b></a> or
<a href='met_comm_createparameter.asp@output=print' target="_blank">
<img src="../images/print.gif" alt="Printer Friendly" border="0" />
<b>Printer friendly page</b></a></p>
<p>W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
<a href="../about/about_copyright.asp">terms of use</a> and
<a href="../about/about_privacy.asp">privacy policy</a>.
</p>
<p><a href="../about/about_copyright.asp">Copyright 1999-2008</a> by Refsnes Data. All Rights Reserved.</p>
<table border="0" width="100%" cellspacing="0" cellpadding="0"><tr>
<td width="60%" align="left">
<a href="../../validator.w3.org/check@uri=referer" target="_blank">
<img src="../images/vxhtml.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../jigsaw.w3.org/css-validator/check@uri=referer" target="_blank">
<img src="../images/vcss.gif" alt="Validate" width="88" height="31" border="0" /></a>
<a href="../../www.w3.org/WAI/WCAG1A-Conformance" title="Explanation of Level A Conformance" target="_blank">
<img src="../images/wai.gif" alt="W3C-WAI level A conformance icon" width="88" height="31" border="0" /></a>
</td>
<td>
<a href="../xhtml/xhtml_howto.asp" target="_top">W3Schools was converted to XHTML in December 1999</a>
</td></tr>

</table>
</td></tr>
</table>
</td>


<td width="145" align="center" valign="top">




<iframe style="background-color:#f1f1f1" src="../banners/rightcolumn.asp@secid=ado" height="1850" width="147"
marginwidth="0" marginheight="0" frameborder="0" scrolling="no">
</iframe>

</td>
</tr></table>

</body>
</html>