conn, 2, 2 ?????

Results 1 to 2 of 2

Thread: conn, 2, 2 ?????

  1. #1
    Join Date
    Dec 1969

    Default conn, 2, 2 ?????

    Set conn = Server.CreateObject("ADODB.Connection")<BR>Set Rs = Server.CreateObject("ADODB.Recordset")<BR>conn.ope n "DRIVER=Microsoft Access Driver (*.mdb);DBQ=" & Server.MapPath("../config/databases/toc.mdb")<BR><BR>strsql = "SELECT tblCategory.level, tblCategory.[ID], tblCategory.Sort AS CatSort, tblPages.sort AS LinkSort, tblCategory.[Name] AS CatName, tblCategory.HREF AS CatURL, tblPages.[Name] AS LinkName, tblPages.[href] AS LinkURL"<BR><BR> strsql, conn, 2, 2<BR><BR>What does this last line execute. I mean the numbers 2, 2???<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: conn, 2, 2 ?????, connection, CursorType, LockType);<BR><BR>CursorType defines how the recordset can be iterated through, ie: forward only, static etc, and locktype is what level of recordlocking is performed, so is the connection open to the database while you have a recordset object, or is your recordset readonly. Connected vs Disconnected recordsets!<BR><BR>HTH<BR>Dave

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts