Records returned from a database

  • Thread starter Thread starter Fawn Davies
  • Start date Start date
F

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 ::order::"
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)
 
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
 
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
 
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
 
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
==============================================
 
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.
 
Back
Top