1) in your cfc function's return use: <cfreturn queryConvertForGrid(QGetCountries, arguments.cfgridpage, arguments.cfgridpagesize) /> 2) is there an Application.cfc with an onRequest() method anywhere that the Utilitieslibrary cfc will be affected by? 3) var your cfc variables :)
Azadi Saryev Sabai-dee.com http://www.sabai-dee.com/ Mike Kear wrote: > I am experimenting with the ajax parts of CF8, and I'm following the > video on the Adobe site where it shows how to build a master detail > application using the CF8 inbuilt ajax stuff. > > It has a CFGRID tag, which binds to a cfc method. There's where my > problem arises i think. I have a simply utilities cfc that has some > commonly used methods, one of which is getCountries() which returns a > query containing country names and abbreviations. > > When i call the method using the tags i've always used, i get a query > object which i can dump and it shows exactly what i'd expect. > However when i use CFGrid, bound to the same method, I get an empty > query, and therefore an empty grid. I'be checked that the method > is access=remote, but what else have i missed? > > Here's the CFGrid tag: > > <cfform scriptsrc="/cms/forms/scripts" > > <cfgrid name="TrialGrid" format="html" pagesize="15" > bind="cfc:cfcs.utilities.utilitieslibrary.GetCountriesGrid( > {cfgridpage},{cfgridpagesize},{cfgridsortcolumn},{cfgridsortdirection} > )" bindonload="yes" > > <cfgridcolumn name="country" header="Country" display="yes" /> > <cfgridcolumn name="countrycode" header="Country Code" display="yes" /> > <cfgridcolumn name="countryid" header="countryid" display="no" /> > </cfgrid> > </cfform> > > > and here's the method in the Utilitieslibrary cfc : > > <cffunction name="GetCountriesGrid" output="false" returntype="query" > access="remote" hint="Returns a list of countries for drop down list"> > <cfargument name="cfgridpage" required="no" type="string" /> > <cfargument name="cfgridpagesize" required="no" type="string" /> > <cfargument name="cfgridsortcolumn" required="no" type="string" /> > <cfargument name="cfgridsortdirection" required="no" type="string" /> > > <cfquery name="QGetCountries" datasource="thetestdsn"> > SELECT Country, countrycode, countryid FROM Countries ORDER BY Country > </cfquery> > <cfreturn QGetCountries /> > </cffunction> > > Can anyone see why calling this method using CFINVOKE returns a > result and using CFGrid doesnt? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:315006 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
