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

Report · Aug 23, 2011

My DB has 100 unique items and it just stops at the 90th item.

NO errors just does not show the last 10 items.
I am Using a .CFC

I have no max results set in the Grid.

Grid Format is HTML.
89th & 90th row looks good in the DB..

About 2.5 second load time on Godaddy shared hosting.
Thank you.

Report · Aug 23, 2011

We use applet grids and display hundreds if not thousand of records. We also use scroll bars on the grid.

Report · Aug 23, 2011

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

Report · Aug 23, 2011

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

Report · Aug 29, 2011

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.

What happens if you call the URL that the grid is calling directly in your browser? It'll be in JSON, but you should be able to eyeball it and see if what's being returned from the remote call is correct, and then getting munged by the grid; or whether the grid is rendering everything it's getting and for some reason you're not getting the data you're expecting.

--

Adam

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

Photos