rs.open parameter meanings?

[selaine]

I'm an ASP/VBScript newbie and I am trying to understand the different methods of coding for and asp form. In the statement below, which I've seen many times, what does 2, 2 represent? I've also seen different numbers other than 2, 2. How do you know what numbers to use and what they represent?

rs.open "myTable", conn, 2, 2

Also, what's the difference between the above statement and:

rs.open "myTable", conn

Is there a reason why you'd use one method over the other?
Thanks for any help in clearing this up!

 

[GaryC123]

The numbers are to do with the cursor type, lock type etc
If you dont specify then it defaults, check here for a detailed description and explanation

http://www.smartsurat.com/education/ASPScript/recordsetobject1.htm

Saturday 12.00

20.00

3.00am

Sunday [img http