Skip to main content
W
webhead_1
Known Participant
December 1, 2009
Question

maximum output of records from a coldfusion cfc

  • December 1, 2009
  • 2 replies
  • 435 views

I have a CFC component pull records from a database that exist outside my network. I am able to pull the data no problem. My issue is the CFC only returns 800 records. Is there a setting in the Coldfusion admin that will allow users to increase the output?

This topic has been closed for replies.

2 replies

ilssac
ilssac
Inspiring
December 1, 2009

No, because I know of know setting that would restrict the output in the administrator.

The only possible settings that I could imagine having any affect on this are in the data source definition that controls the database driver to connect to whatever database to which you are connecting.

Is this a common database management systems or something unusual using an uncommon driver?

There are settings that sometimes affect how much data is retrieved with drivers but these normally apply to CLOB and BLOB field that are occasionally used.

D
Dan_Bracuk
Inspiring
December 1, 2009

Are you sure it's not a maxrows attribute in your cfquery tag or something like that?

I just wrote a quick one that returns about 1400 records and it was fine.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices