I am currently getting only 1 row of data showing. What do I need to change in the following so I can have more than 1 row?
Const NumPerPage = 1
Dim CurPage, myCon, myRS, strSQL
If Request.QueryString("CurPage") = "" then
CurPage = 1
CurPage = Request.QueryString("CurPage")
Set myRS = Server.CreateObject("ADODB.Recordset")
myRS.CursorLocation = adUseClient
myRS.CacheSize = NumPerPage
strSQL = "SELECT * FROM tbl_bro"
myRS.Open strSQL, myCon
myRS.PageSize = NumPerPage
TotalPages = myRS.PageCount
myRS.AbsolutePage = CurPage
Hope to hear...TIA.
(Why is there NOT MUCH activity on the WROX website?)