2 Replies Latest reply on Dec 1, 2009 9:21 AM by ilssac

    maximum output of records from a coldfusion cfc

    webhead_1 Level 1

      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?

        • 1. Re: maximum output of records from a coldfusion cfc
          Dan Bracuk Level 5

          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.

          • 2. Re: maximum output of records from a coldfusion cfc
            ilssac Level 5

            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.