Limit to display matching records in a database does not work

[Guest]

I have been working on a website which allows the user to search a database
and display matching records in a results area. The search works great and
results displays matching records. My problem is that I set a limit of 5
records to be displayed on a page. A query which produces more than 5 matches
in the database displays the first 5 and FrontPage places navigation buttons
after the 5th one. When I click on a button to list the next 5 records, I get
the error message I have designed when no matches are made. "Sorry but I
found no matches for your query." I know there are more records to be
displayed because FP shows page 1 of 2 in the area next to the buttons. Is
this a FP problem or am I doing something wrong. I also use hyperlinks in the
search page to present additional data for displayed records and that works
great too.
Thank you in advance, Regards,

 

[Kathleen Anderson [MVP - FrontPage]]

What version of FrontPage are you using and is it fully patched?

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
FrontPage Support: http://www.frontpagemvps.com/

 

[Stefan B Rusynko]

If hand coding your ASP,
- check your code for setting adOpenStatic, adLockReadOnly, adCmdText from say a adovbs.inc include file
- or use their values if you don't have a current adovbs.inc
(adOpenStatic = 3 , adLockReadOnly = 1, adCmdText = &H0001
- see http://www.asp101.com/samples/db_paging.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


|I have been working on a website which allows the user to search a database
| and display matching records in a results area. The search works great and
| results displays matching records. My problem is that I set a limit of 5
| records to be displayed on a page. A query which produces more than 5 matches
| in the database displays the first 5 and FrontPage places navigation buttons
| after the 5th one. When I click on a button to list the next 5 records, I get
| the error message I have designed when no matches are made. "Sorry but I
| found no matches for your query." I know there are more records to be
| displayed because FP shows page 1 of 2 in the area next to the buttons. Is
| this a FP problem or am I doing something wrong. I also use hyperlinks in the
| search page to present additional data for displayed records and that works
| great too.
| Thank you in advance, Regards,
| --
| RWS FLorida