Records returned from a database

[Fawn Davies]

I have pages set up through FrontPage 2003 with forms that submit
information to a database and other pages that display the database results.

A maximum number of records that are displayed is 256. I'd like to be able
to display more, but it seems like FrontPage is limiting me to 256. I can't
find anything in the MS knowledge database regarding this issue.

Can anyone help?

The code looks like:

<% ' FP_ASP -- ASP Automatically generated by a FrontPage Component. Do not
Edit.
FP_LCID = 1033 %>

<% end if %>
<%
fp_sQry="SELECT * FROM tbltriallog ORDER BY :rder::"
fp_sDefault="order=startdate asc"
fp_sNoRecords="No records returned."
fp_sDataConn="Whiteboard2"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=False
fp_sMenuChoice="filenumber"
fp_sMenuValue="filenumber"
fp_sColTypes="&ID=3&startdate=200&plaintiff=200&insured=200&pa=200&da=200&venue=200&allegation=201&demand=3&claimcommittee=201&laereserve=3&indemnity=3&examiner=200&outcome=200&closedate=200&judge=200&filenumber=3&Remote_computer_name=200&User_name=200&Browser_type=200&Timestamp=135&"
fp_iDisplayCols=16
fp_fCustomQuery=True
BOTID=2
fp_iRegion=BOTID
%>


Thanks -

Fawn Davies

Communications Specialist

___________________________________



PMSLIC | Always With You

717.796.5476 or 800.445.1212 | (e-mail address removed)

 

[Kathleen Anderson [MVP - FrontPage]]

When you are going through the steps in 'Insert Database Results' there is a
checkbox that you can uncheck that will allow all records to be returned.
It's either the last step or the next-to-last step.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Fawn Davies]

Kathleen - thank you, I found it. Unfortunately, if I go back and uncheck
this box FP is going to recreate the results region and I'm going to lose
the custom coding that was applied afterward. Darn.

Fawn

 

[Kathleen Anderson [MVP - FrontPage]]

You could try finding this i-maxrecords="256" in the gray-colored code and
changing it to i-maxrecords="0", but that *may* also cause you a problem
with the page as well.

I'm not sure why that option even had to be in there in the first place - I
always turn it off and can't think of a reason why anybody would want it on.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others

 

[Thomas A. Rowe]

If you have a very large database. Example: On the MS site you are/were limited to 200 search
results.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================

 

[Fawn Davies]

Yep, I tried changing the gray coded area to 1000 in all places but it
doesn't like that. I guess when it says don't edit, it means it!

I'm thinking this must have been in there as a default (256 seems random
also), and I, too, have no idea why it would be turned on automatically. I
overlooked it when this was created, but it's sure causing me problems now.

Thanks for your help.