CF-SQL Select scripts in cfquery records get limited to print 9999 records when we dump it

Hi,

While using Select scripts in cfquery records get limited to print 9999 records only when we dump it with cfdump.

We are using the below code

<cfoutput> CF-MSSQL-Select scripts </cfoutput>

Select top 10020 custid from customers

</cfquery>

When we execute this code in cfdump only lists 9999 records.

Is there any way to increase the data limit to 50,000 plus?

Please see the below screenshot attached.

Please advise.

Thank you
Jibin

This topic has been closed for replies.

Sign up