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
Click here to design a Stunning Flash Website for Free
Wix is a revolutionary web design tool that provides anyone with the possibility to create professional and beautiful websites for free.
With e-commerce features, search engine visibility and many more professional tools, Wix is the ultimate solution for creating a spectacular site while saving tons of money.
| 
