Does cfgrid have a max result from a query it will display?

Thanks for the replies. If there is no restrictions on how

many records a HTML CFGRID will display then it is some thing in my code.   It is just weird because I have not touched

the code in weeks I just hit 100 records in my admin section and decided to look

at my user side.  I deleted a bunch of

records in the sql database to see if maybe I had some issues within one of

them with. No luck. The deleted rows did disappeared from my grid results.  Even after I add them back in they now do

not show up.. Copying a row in the table same result. I am now down to 83 records displaying. I have a separate page

with the same query placing the data into a table. It works fine. I am also

running it on my dev machine at home and pulling the data from the Godaddy SQL server. Same issue on my home box.  I am

going to reduce down the query of the CFGRID as well as move the database to my

local box.  The only thing I have done

recent to the .cfc was add a date field. I am using:

CONVERT(VARCHAR(11), VinyardId.DateUpdated, 101) AS date

in the Select option of the query to formatingt the date. I

removed this and receive the same result.

I will keep trouble shooting.. Who knows maybe I will be

lucky and they will reboot the servers and it will be working again..

Thank you,

- Scott

From: Adam Cameron. <forums@adobe.com>

To: Scott Pelletier <scott_pelletier@yahoo.com>

Sent: Tuesday, August 23, 2011 9:48 AM

Subject: Does cfgrid have a max result from a query it will display?

OK, part of your troubleshooting this should be to factor-out elements that are not relevant to the issue, and pare it back to the minimum amount of code that demonstrates the problem.  If you can't work out from that reproduction case what the problem is, post the reproduction case here so we can look at what you're doing. Your repro code should not have any external dependencies like DB connections (so, like, generate the sample data with code).

--

Adam