Name: Leaf Asp Pagination Class
Name:ShowoPage(vbsclass)
RCSfile:ReadMe.txt
Revision:0.12.20051114.f
Author:Yehe(leaf)
Released:2005-11-1409:40:13
Description: ASP paging class, supports access/mssql/mysql/sqlite
Contact:QQ:311673MSN:[email protected]:[email protected]
WebSite: http://www.yehe.orghttp://www.showo.com
------------------------------------------------
Licenses:
This program complies with the GPL protocol.
The original address of the protocol: http://www.gnu.org/licenses/licenses.cn.html#GPL
------------------------------------------------
Thanks:
Keluo: Thanks to the core part of mssql pagination
Arbiter: Thanks for some paging ideas
Talented man: Thanks for the promotion
foxty:Thanks for the paging ideas
------------------------------------------------
Install:
1. For specific call methods, you can see the demo's asp document.
2. For the mssql stored procedure version, please first execute the sp_Util_Page.sql file to add stored procedures.
3.sp call method:
execsp_Util_Page440000,4,10,''MID'',''MID,ip1,ip2,country,city'',''tbTempPage'',''1=1'',''midasc''
Record the number of records (existing values: sequence external assignment, 0 execute count), current page number, record number per page, primary key, field, table, condition (no where required), sorting (no orderby required, asc and desc characters required)
If you do not sort by primary key, the primary key characters cannot appear in the sorting assignment.
------------------------------------------------
Release:
0.12
1. Fix the text field type bug
2. Stored procedure bug fix
3. Code correction
0.11
1. The stored procedure has added pagination under non-primary key sorting
2. Removed the non-storage procedure version pagination of mssql
0.10:
1. Simplify the conditions
2. Stored process optimization
0.09:
1. Sorting and judging part optimization
0.08:
1.vbsbug fix
0.07:
1. Bug fixes, including vbs class and js
0.06Beta:
1.js browser compatibility optimization
2. Bug fixes for several functions of class
0.05Beta:
1. Comprehensive code optimization, mysql/sqlite support
2. Modify the parameter input method
0.04Beta:
1. To adapt to multiple database integration pages just like calling code
2.js removes the form and supports static submission
3. Added stored procedures
0.03Beta:
1. The publicly released display is 0.02, which is actually 0.03, and is divided into AC version and mssql version version.
2.js bug fix
3. Written as a class to further facilitate call
0.02Beta:
1. Add support for mssql
2. Encapsulated into a function version for easy calling
3.js file optimization
0.01Beta:
1. Not written as a function, but I found a faster ac pagination method
2. Display the pagination style in js
------------------------------------------------
File:
db/IP.mdbaccess test database
db/IPmssql backup test database
Cls_vbsPage.asp pagination class
Cls_jsPage.jsjs paging style
sp_Util_Page.sqlmssql stored procedure
demoAC.aspac pagination call demonstration
demoMSSQL.aspmssql call demonstration
demoMSSQL_SP.aspmssql stored procedure call demonstration
Cls_vbsPage.asp
<%
ClassCls_vbsPage
PrivateoConn''Conn''Conn Connect Object