Skip to main content
Inspiring
March 11, 2008
Question

CFGrid in CF8

  • March 11, 2008
  • 10 replies
  • 1021 views
I'm trying to create a very basic data grid using CF8, but it shows no rows every time. I know the query works on it's own. What am I missing?
This topic has been closed for replies.

10 replies

Inspiring
March 26, 2008
The ONLY way I can get it to work is to bind to a url.

bind= "url:dspSearchResults_2.cfm?page={cfgridpage}&pageSize={cfgridpagesize}&sortCol={cfgridsortcolumn}&sortDir={cfgridsortdirection}"
BKBK
Community Expert
Community Expert
March 26, 2008
Oh, and I should emphasize that my suggestion is in case onRequest turns out not to be the problem. If it was, Natg504 and Larksys should have at least obtained a Javascript error message.



BKBK
Community Expert
Community Expert
March 26, 2008
Azadi wrote:
your previous post surely read like you advised the OP to change the access attribute in the cffunction tag.

I'm afraid that's what I did. I should have said more. My suggestion is simply that the OP should check that the component is OK -- with public access and without the grid. I would vote for the query as the first suspect.


Inspiring
March 26, 2008
i understand you. it's just that your previous post surely read like you
advised the OP to change the access attribute in the cffunction tag.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
BKBK
Community Expert
Community Expert
March 25, 2008
Azadi wrote:
from the OP's last line in the cfc (queryconvertforgrid function used) i
assume this cfc method is populating a cfgrid... which requires access
attribute to be set to 'remote'


I understand. What I suggest is to test with and without access="remote", using code like

<cfset surveyObject = createobject("component", "survey")>
<cfset surveyStruct = surveyObject.getSurvey(1,2,'Q1','asc')>
<cfdump var="#surveyStruct#">

Inspiring
March 25, 2008
from the OP's last line in the cfc (queryconvertforgrid function used) i
assume this cfc method is populating a cfgrid... which requires access
attribute to be set to 'remote'

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
BKBK
Community Expert
Community Expert
March 25, 2008
Related to what Azadi says: What happens when you leave out the attribute access="remote"?

Inspiring
March 21, 2008
make sure you have no onRequest() method defined in your
Application.cfc. i mean NONE defined, not even an empty method declaration.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/
Inspiring
March 20, 2008
More importantly, why can't we get an answer?
Inspiring
March 20, 2008
I have the same problem. I get an error if I use returntype="struct".