ADO State Property
 Complete Recordset Object Reference
The State property returns a value that describes if the object is open,
closed, connecting, executing or retrieving data. The value returns an ObjectStateEnum value.
Default is adStateClosed.
This property can be used with the Command, Connection, Record,
Recordset, and Stream object.
The State property can have a combination of values. If a statement is executing, this property will have a combined value of adStateOpen and
adStateExecuting.
Syntax
Example - For a Command object
<%
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")
response.write(comm.State)
conn.close
%>
|
Example - For a Connection object
<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open "c:/webdata/northwind.mdb"
response.write(conn.State)
conn.close
%>
|
ObjectStateEnum Values
Specifies whether an object is open or closed, connecting to a data source,
executing a command, or retrieving data.
| Constant |
Value |
Description |
| adStateClosed |
0 |
The object is closed |
| adStateOpen |
1 |
The object is open |
| adStateConnecting |
2 |
The object is connecting |
| adStateExecuting |
4 |
The object is executing a command |
| adStateFetching |
8 |
The rows of the object are being retrieved |
Complete Recordset Object Reference
Reliable, Affordable, Feature-Rich Web Hosting!
Take the uncertainty out of Web hosting and let
GoDaddy.com put service, performance and value back in. No matter which
hosting type or plan you choose, your site receives 24/7
maintenance and protection in our world-class data center. Plus,
you get the expert, friendly service you deserve, from the
world's largest hostname provider.
With three plans to choose from and
prices starting at just $4.99 per month, GoDaddy.com is sure to have a plan that's
right-sized and right-priced just for you!
All plans feature FREE 24x7 setup, FREE 24x7 monitoring, best-
of-breed routers, firewalls and servers, 24x7 onsite physical security
and access to our exclusive Go Daddy Hosting Connection, THE place
to install over 30 FREE applications. Virtual Dedicated and Dedicated
Server plans also available.
Visit GoDaddy.com today.
Virtual Dedicated, Dedicated Server and unlimited plans also available.
Save 20% on 12 months or more of shared web hosting - Enter code w3s20off at checkout
| 
