Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recordset parameters 1

Status
Not open for further replies.

JazzLeg

Programmer
Aug 22, 2002
63
GB
Hi,

I'm using ASP and connecting to an SQL7 database.
This is part of a statement to form a recordset.

Code:
rs.Open MySQL,cnn1,1,3

Does anyone know what the '1' and '3' do?

Thanks
 
The 1 and 3 are ADO Constants that are simply options of the Open method.

If you declare the following file (check path for your machine) at the start of your page then you can use the more meaningful constant names instead of the numbers:

<!-- METADATA TYPE=&quot;typelib&quot; FILE=&quot;C:\Program Files\Common Files\System\ado\msado15.dll&quot; -->

In the example you gave above:

1 = adOpenKeyset
3 = adLockOptimistic Tony
reddot.gif WIDTH=500 HEIGHT=2 VSPACE=3

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top