Hello
I have a cfgrid that is not showing any data. All I can see are the row
headings and page selectors. The component is returning three rows and a bunch
of empty rows (as per the Coldfusion AJAX logger). If I use a query as the
grid's data source it works fine.
I am just learning all this so would be grateful for any help
Thanks in advance
Catriona
cfgrid:
<cfform name="frmSelectUser" action="#cgi.script_name#" method="post"
format="html">
<cfgrid name="userList" format="html" height="300"
bind="cfc:ammc.common.cfc.UserDetails.getDataOwnerUsers(
{cfgridpage},{cfgridpagesize},cfgridsortcolumn},cfgridsortdirection},
'#SESSION.login.dataOwnerId#')">
<cfgridcolumn name="USERS_ID" display="false">
<cfgridcolumn name="FIRST_NAME" header="First name"
display="true">
<cfgridcolumn name="LAST_NAME" header="Last name"
display="true">
</cfgrid>
</cfform>
component function:
<cffunction name = "getDataOwnerUsers"
access="remote"
output="false"
returnType="struct"
hint="Browse method for Ajax manage user grid"
>
<!---verifyclient="true"--->
<cfargument name="page"
type="numeric"
required="true">
<cfargument name="pageSize"
type="numeric"
required="true">
<cfargument name="gridsortcolumn"
type="string"
required="false"
default="">
<cfargument name="gridsortdir"
type="string"
required="false"
default="">
<cfargument name="dataOwnerId"
type="numeric"
required="true"
hint = "The data owner of the user that is managing
users">
<cfset var qryDataOwnerUsers = "">
<cfquery name="qryDataOwnerUsers"
datasource="#APPLICATION.dataSource#">
SELECT USERS_ID, FIRST_NAME, LAST_NAME
FROM AMMC.USERS
WHERE AMMC.USERS.DATA_OWNER_ID = <cfqueryparam
cfsqltype="cf_sql_numeric" maxlength="10" value="#ARGUMENTS.dataOwnerId#">
<cfif ARGUMENTS.gridsortcolumn neq "" and
ARGUMENTS.gridsortdir neq "">
ORDER BY #ARGUMENTS.gridsortcolumn#
#ARGUMENTS.gridsortdir#
</cfif>
</cfquery>
<cfreturn QueryConvertForGrid(qryDataOwnerUsers,
ARGUMENTS.page, ARGUMENTS.pageSize)>
</cffunction>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;207172674;29440083;f
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:321833
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
