Quick ASP ADO queston - constants in rs.open line?

[zensunni]

In a line like this:

Set RSInsert = Server.CreateObject("ADODB.Recordset")
RSInsert.Open "Tablename", objConn, 1, 3, 2

What do the numbers mean, and is there anywhere I can go to find all the definitions of them?

[jhardman]

Welcome to the scripts dn. These constants after the objConn specify the type of cursor (whether you can only scroll through the RS in one direction) the lock type (whether you are locking the db for editing) etc. There is a file called "ADOVBS.inc" which provides constant names for each of these constants which helps keep them separate in my mind. see this article

Jared

[zensunni]

One thing that google is terrible for is not being able to search a sequence like ", 1, 3, 2". Now, I have a starting point. This is great. Thanks a lot.

[zensunni]

Hmm... This article tells me how to make the numbers mean something, however, I'm wondering what order goes what. Is is just chronological compared to the .inc file?

So, me specifying 3, 2, 1 and 1, 2, 3. would be what?

Thanks for any help or leads... I'll post info if I find it.

[Edit] Bingo: http://www.w3schools.com/ado/met_rs_open.asp