Copy link to clipboard
Copied
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?
Copy link to clipboard
Copied
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.
Copy link to clipboard
Copied
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.