Skip to main content
K
kslane
Participant
January 5, 2007
Question

MAXROWS attribute causing problems with StoredProc

  • January 5, 2007
  • 1 reply
  • 230 views
I was doing some testing and wanted to throttle the resultset so I put a MAXROWS attribute in my CFPROCRESULT tag. Everything worked fine, but now I can't get my results back up to where they're supposed to be. I set MAXROWS=1000 and only got 1000 records. Then, I removed MAXROWS, but I'm still only getting 1000 records. So, I put MAXROWS back in and set it to 2000. I got 2000 records, then took MAXROWS back out again. Now I'm consistently getting 2000 records. Is this cached somewhere?
    This topic has been closed for replies.

    1 reply

    A
    Anonymous
    January 6, 2007
    Sounds like it could be the second issue mentioned here. You could try the hotfix if you are running 7.02 or use the cumulative hot fix chf7020001 now available.
    K
    kslaneAuthor
    Participant
    January 8, 2007
    Wow, that sounds exactly like what I'm experiencing. Thanks. I'll give this a try.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices