Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

CFGrid in CF8

Explorer ,
Mar 11, 2008 Mar 11, 2008
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?
TOPICS
Database access
973
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Mar 20, 2008 Mar 20, 2008
I have the same problem. I get an error if I use returntype="struct".
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Mar 20, 2008 Mar 20, 2008
More importantly, why can't we get an answer?
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 20, 2008 Mar 20, 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/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 24, 2008 Mar 24, 2008
Related to what Azadi says: What happens when you leave out the attribute access="remote"?

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 24, 2008 Mar 24, 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/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 25, 2008 Mar 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#">

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Mar 25, 2008 Mar 25, 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/
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 26, 2008 Mar 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.


Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
Mar 26, 2008 Mar 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.



Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Explorer ,
Mar 26, 2008 Mar 26, 2008
LATEST
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}"
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources