DRW multi column display - page buttons

  • Thread starter Thread starter LScal
  • Start date Start date
L

LScal

I've implemented the DRW multi-column results procedure found here:
http://home.att.net/~codeLibrary/FrontPage/multi.htm

I modified it to display multiple db columns within each cell of a
multi-column HTML table with a set amount of records per page. For the most
part it gives me what I want. The problem is that the default FP page
navigation buttons don't work properly. The page count indicates the total
pages, if I wasn't displaying multiple columns. And, of course, the
navigation of these buttons is not working - page 2 duplicates page 1, page
4 duplicates page 3, and so on.

Anyone know if where I can find a fix for this?
Where can I find out how to replace the default navigation buttons with my
own?

Thanks
 
LScal said:
I've implemented the DRW multi-column results procedure found here:
http://home.att.net/~codeLibrary/FrontPage/multi.htm

I modified it to display multiple db columns within each cell of a
multi-column HTML table with a set amount of records per page. For
the most part it gives me what I want. The problem is that the
default FP page navigation buttons don't work properly. The page
count indicates the total pages, if I wasn't displaying multiple
columns. And, of course, the navigation of these buttons is not
working - page 2 duplicates page 1, page 4 duplicates page 3, and so
on.

Anyone know if where I can find a fix for this?
Click to expand...

I would take a look at the fpdbrgrn1.inc file in the _fpclass folder.
Where can I find out how to replace the default navigation buttons
with my own?
Click to expand...

Here's how you can change the text, color, font, etc. on the existing
buttons:
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#buttons


--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx
 
Thanks. I will try out the button color and font changes soon.

I checked all the inc files in the _fpclass folder and really can't see any
obvious way to change the Navbar results. Any other ideas?
 
I think it may be in this code in the fpdbrgrn1.inc file:



if fp_iPageSize > 0 then
fp_iAbsPage = 1
fp_sVal = Session(fp_sEnvKey)
if fp_sVal <> "" then
fp_iAbsPage = CInt(fp_sVal)
end if

fp_rs.PageSize = fp_iPageSize
if fp_iAbsPage > fp_rs.PageCount then fp_iAbsPage = fp_rs.PageCount
fp_rs.AbsolutePage = fp_iAbsPage
if fp_rs.PageCount = 1 then fp_fShowNavbar = False

select case fp_sMoveType
case ""
' do nothing
case fp_sFirstLabel
fp_rs.AbsolutePage = 1
case fp_sPrevLabel
if fp_rs.AbsolutePage > 1 then fp_rs.AbsolutePage = fp_rs.AbsolutePage -
1
case fp_sNextLabel
if fp_rs.AbsolutePage < fp_rs.PageCount then fp_rs.AbsolutePage =
fp_rs.AbsolutePage + 1
case fp_sLastLabel
fp_rs.AbsolutePage = fp_rs.PageCount
case else
' do nothing
end select

fp_iAbsPage = fp_rs.AbsolutePage
Session(fp_sEnvKey) = fp_iAbsPage



--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx
 
Thanks. I'll give it a try and let you know.


Kathleen Anderson said:
I think it may be in this code in the fpdbrgrn1.inc file:



if fp_iPageSize > 0 then
fp_iAbsPage = 1
fp_sVal = Session(fp_sEnvKey)
if fp_sVal <> "" then
fp_iAbsPage = CInt(fp_sVal)
end if

fp_rs.PageSize = fp_iPageSize
if fp_iAbsPage > fp_rs.PageCount then fp_iAbsPage = fp_rs.PageCount
fp_rs.AbsolutePage = fp_iAbsPage
if fp_rs.PageCount = 1 then fp_fShowNavbar = False

select case fp_sMoveType
case ""
' do nothing
case fp_sFirstLabel
fp_rs.AbsolutePage = 1
case fp_sPrevLabel
if fp_rs.AbsolutePage > 1 then fp_rs.AbsolutePage = fp_rs.AbsolutePage -
1
case fp_sNextLabel
if fp_rs.AbsolutePage < fp_rs.PageCount then fp_rs.AbsolutePage =
fp_rs.AbsolutePage + 1
case fp_sLastLabel
fp_rs.AbsolutePage = fp_rs.PageCount
case else
' do nothing
end select

fp_iAbsPage = fp_rs.AbsolutePage
Session(fp_sEnvKey) = fp_iAbsPage



--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
blog: http://msmvps.com/spiderwebwoman/category/321.aspx
Click to expand...
 
By luck, I discovered that I had the page messed up. After a rebuild of the
entire page it works fine without having to make any changes to
fpdbrgn1.inc.
Thanks again.
 
Back
Top