ADO CommandType Property
 Complete Command Object Reference
The CommandType property sets or returns a CommandTypeEnum
value that defines the type of the Command object. Default is adCmdUnknown.
If you do not specify the type, ADO will need to contact the provider to determine the type of the command.
However, if you do specify the type, ADO will be able to process the command faster.
Syntax
Example
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
set comm=Server.CreateObject("ADODB.Command")
comm.CommandText="orders"
comm.CommandType=adCmdTable
response.write(comm.CommandType)
conn.close
%>
|
CommandTypeEnum Values
| Constant |
Value |
Description |
| adCmdUnspecified |
-1 |
Does not specify the command type argument. |
| adCmdText |
1 |
Evaluates CommandText as a textual definition of a command or stored
procedure call. |
| adCmdTable |
2 |
Evaluates CommandText as a table name whose columns are all returned
by an internally generated SQL query. |
| adCmdStoredProc |
4 |
Evaluates CommandText as a stored procedure name. |
| adCmdUnknown |
8 |
Default. Indicates that the type of command in the CommandText
property is not known. |
| adCmdFile |
256 |
Evaluates CommandText as the file name of a persistently stored
Recordset. Used with Recordset.Open or Requery only. |
| adCmdTableDirect |
512 |
Evaluates CommandText as a table name whose columns are all returned.
Used with Recordset.Open or Requery only. To use the Seek method, the
Recordset must be opened with adCmdTableDirect. This value cannot be
combined with the ExecuteOptionEnum value adAsyncExecute. |
Complete Command Object Reference
Make your web applications look like a million bucks
|
|
Most web applications today use boring methods to present data to their viewers using grids or simple HTML tables. FusionCharts induces "life" into the web applications by converting monotonous data into lively charts, gauges & maps.
FusionCharts works with all technologies like ASP, ASP.NET, PHP, ColdFusion, Ruby on Rails, JSP, HTML pages etc.
and connects to any database to render animated & interactive charts. It takes less than 15 minutes and no expertise
whatsoever to build your first chart and just a glance of it to captivate your audience. This fact is endorsed by our
12,000 customers and 150,000 users which include a majority of the Fortune 500 companies.
And yeah, your applications could look like a million bucks by spending just $69.
So go ahead, download your
copy of FusionCharts and start "wow-ing" your customers now!
|
 |
W3Schools' Online Certification Program
The perfect solution for professionals who need to balance work, family, and career building.
More than 4000 certificates already issued!
|
The HTML Certificate documents your knowledge of HTML, XHTML, and CSS.
The JavaScript Certificate documents your knowledge of JavaScript and HTML DOM.
The XML Certificate documents your knowledge of XML, XML DOM and XSLT.
The ASP Certificate documents your knowledge of ASP, SQL, and ADO.
The PHP Certificate documents your knowledge of PHP and SQL (MySQL).
|
