CFGRID not displaying data from query

Forum|Forum|15 years ago
September 21, 2010
3 replies
2365 views

Hello,

I have a very simple query, which is being used to populate cfgrid. The headers and paging display, the grid behaves as if it's laoding data, but never does. I've run the query in the background and it returns 4 rows.The CFC calling the query simpy takes in the parameters and returns the query.

The code is as follows:

</cfgrid>

There seems to be a javascript error on the page, which says Exception thrown but not caught, could this be the cause of the problem?

Thanks.

This topic has been closed for replies.

BKBK

Community Expert

bind="cfc:#request.ictcomponent_path#.getSystemMessages({cfgridpage}, {cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection},'#session.ds n#', '#variables.userId#','#variables.service_id#','#adminAccess#')"

You may not pass strings in a bind like that. You have to fool Coldfusion a little.

My favourite way is to pass variables as hidden form fields. First, store the values as follows:

<cfinput name="session_dsn" value="#session.dsn#"               type="hidden">
<cfinput name="userId"               value="#variables.userId#"        type="hidden">
<cfinput name="service_id"        value="#variables.service_id#" type="hidden">
<cfinput name="adminAccess" value="#adminAccess#"            type="hidden">

Then replace your list

'#session.dsn#', '#variables.userId#','#variables.service_id#','#adminAccess#'

with the list

{session_dsn}, {userId}, {service_id}, {adminAccess}

A

Anonymous

It might be happening if you have a application.cfc file.

From livedocs:

Do not implement the onRequest method in any Application.cfc file that affects .cfc files that implement web services, process Flash Remoting or event gateway requests; ColdFusion will not execute the requests if you implement this method.

I hope this helps..