piątek, października 14, 2005

Stronicowanie a ADO

  1. ADO pozwala stronicować wiersze w bazie z uwagi na impelemntację własciwosci:
    Paged Table Displays by Charles Carroll & Jeff Emrich
    This page demonstrates how to retrieve a recordset divided up into pages, and to only select data from a specified page. It does not in any way store a recordset or connection in memory when the page is not accessed unlike many solutions you will read about. The ADO properties that make this magic possible are .AbsolutePage, .PageCount and .PageSize.
  2. Inny link - http://www.codeproject.com/asp/rspaging.asp
  3. Jeszcze inny - http://www.codeproject.com/asp/bgrid.asp
  4. Inny przykład - http://www.4guysfromrolla.com/webtech/121298-1.shtml
  5. Lub tu - http://support.microsoft.com/kb/q202125/
  6. http://support.sas.com/rnd/eai/oledb/app_cursorlocktypes.htm#serverside
  7. Tutoriale o ADODB dla PHP i Pythona - http://adodb.sourceforge.net/#download
  8. Zasoby o ADODB dla PHP i nie tylko - http://php.resourceindex.com/Functions_and_Classes/Database_Management/
  9. PHP DataGrid - http://phpscripts.pallettgroup.com/demos/phpdatagrid/manual.html
  10. http://authors.aspalliance.com/brettb/ASPWatchArticles.asp - o APS
  11. http://authors.aspalliance.com/brettb/Default.asp - Wszystko o ASP
  12. Problem gdy "provider" nie wspiera "bookmark"-ow wtedy zamiast:
  • thisrsLinks.Open strSQL, conn, adOpenStatic, adLockReadOnly, adCmdTextTo
  • thisrsLinks.Open strSQL, conn, adOpenDynamic, adLockReadOnly, adCmdText

Pełna dyskusja na ten temat: http://forums.aspfree.com/archive/t-52065/Current-Recordset-does-not-support-bookmarks

Brak komentarzy: