ADO Prepared Property
 Complete Command Object Reference
The Prepared property sets or returns a Boolean value that, if set to True,
indicates that the command should save a prepared version of the query specified in the CommandText property
before execution.
This could slow down the command's first execution, but after the
first execution the provider will use the compiled version, which results in a
faster execution.
Syntax
objcommand.Prepared=true or false
|
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.ActiveConnection=conn
comm.CommandText="orders"
comm.Prepared=true
response.write(comm.Prepared)
conn.close
%>
|
Complete Command Object Reference
Want To Be A Web Master?
If you want to be a Web Master, you will have to host your web site with an ISP (Internet Service Provider).
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.
Visit MaximumASP
| 
HOME
Printer friendly page
