I am trying to set a cfgrid to bind to a cfc but for some reason it is not
showing any data. The grid is loaded and it does not error out or anything it
just does not show any data in the grid. Here is the code:
Display Page -
<cfform name="productsForm">
<cfgrid name="productsGrid" format="HTML" pagesize="10" selectmode="row"
bind="cfc:data.getProducts({cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection})">
<cfgridcolumn name="sku" header="SKU" width="300">
<cfgridcolumn name="style" header="Style" width="300">
</cfgrid>
</cfform>
CFC Page:
<cfcomponent>
<cffunction name="getProducts" access="remote">
<cfargument name="page" required="yes">
<cfargument name="pageSize" required="yes">
<cfargument name="gridsortcolumn" required="yes">
<cfargument name="gridsortdirection" required="yes">
<cfquery name="queryProducts" datasource="atc">
SELECT sku, style
FROM products
<cfif gridsortcolumn neq ''>
order by #gridsortcolumn# #gridsortdirection#
</cfif>
</cfquery>
<cfreturn queryconvertforgrid(queryProducts,page,pagesize)>
</cffunction>
</cfcomponent>
Any help on this would be great.
Thanks!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Get involved in the latest ColdFusion discussions, product
development sharing, and articles on the Adobe Labs wiki.
http://labs/adobe.com/wiki/index.php/ColdFusion_8
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285602
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
