Ext.data.CFQueryReader v1.2

[CutterBl]

The CFQueryReader custom data reader, used for interpretting Adobe ColdFusion's JSON response of a query object, has been updated to support ExtJs 3.x. There is still backwards compatibility for Ext 2.x, and the download includes a small example using Aaron Conran's DirectCFM + CFQueryReader + Ext.Direct.

The CFQueryReader project is available for download on RIAForge.

[azadisaryev]

any particular reason why cfqueryreader would fail to load data into the grid on windows server 2008?

it works fine on win xp, but on 2k8 the grid appears without any data...
using cfjsonreader instead of cfqueryreader makes the data show up in the grid on 2k8 just fine.

any ideas?

[UPDATE 16-Nov-2009]
apparently, nothing to do with 2k8 server - cfqueryreader does not work with ext js 3.0.3 (yet).

Azadi

[zlesko]

Has anyone tried CFQueryReader with the newest version of Ext, 3.0.3? Had this working great with v3.0.0 and now the stores are not being populated.

Thanks for any ideas...

[azadisaryev]

right you are - it does not work at all...
i guess that was why my friend could not make it work on his win 2k8 server... i was still using ver 3.0.0 when trying to help him solve the issue and kept telling him "it works just fine for me"!

[UPDATE: my friend got his data into the grid when he switched to using cfjsonreader instead of cfqueryreader.]

hmm... strange thing, though: the ext js download i was using said it was 3.0.3, but the files inside were from 3.0.0!

Azadi

[CutterBl]

The recent 3.0.3 update appeared to break CFQueryReader. Detailed analysis, refactor, and testing revealed that an internal method [getJsonAccessor()] of the Ext.data.JsonReader class had been changed [now createAccessor()]. Changes have been made to CFQueryReader to allow for either, dependent upon which is available.

[CutterBl]

BTW, that latest update can be downloaded from the CFQueryReader project page on RIAForge.

[azadisaryev]

Thanks, Steve!

[zlesko]

Thanks! Don't you just love when they do that...

[PatJ]

BTW, that latest update can be downloaded from the CFQueryReader project page on RIAForge.

I see there haven't been many posts here recently, but I'm new to ExtJS and I've been gutting it out for the past couple of weeks. I have a nice UI built but am having difficulty getting data from CF into the various Ext components - namely the grid (the forms will be next). I have read all the posts here about CFQueryReader and have tried to implement a small test but can't seem to get data loaded. I'm also somewhat new to Firebug and am having difficulty finding information on the JSON data. I know my CFC is working because I have seen the JSON data by calling the method directly through the URL line on the browser and placing a "console.info" call tells me there is no data in the store.

I hate to admit it but I'm also new to message forums so I apologize if I'm not putting things in the right place. Any help in this area is certainly appreciated and would help me in moving along with our project. I'm sure the fix is simple - I keep thinking it is the URL path - but I have tried a full http:\\ specification as well and still no results. I'm posting my code below - I wasn't able to upload the file. Hopefully someone can enlighten me!!

Thanks,
Pat

CFQueryReader v1.2
ExtJS v.3.2.1
CF8


var myDataModel = [
{ name: 'Title Number', mapping: 'TitleID'},
{ name: 'Title', mapping: 'TITLE' }
];

var myCFReader = new Ext.data.CFQueryReader({id:'TitleID'},myDataModel);

var store = new Ext.data.Store({
url: '/myroot/cfc/test.cfc',
baseParams: { method: 'gettitles', returnformat: 'JSON'},
fields: myDataModel,
reader: myCFReader,
sortInfo:{field:'TitleID', direction:'ASC'}
});

console.info('Store count = ', store.getCount());

[CutterBl]

Can you paste in a copy of your JSON return? On the Console tab in Firebug you should see a line where the Ajax request is being made. You can expand that line item (the plus sign icon on the left) and be able to view the response on one of the tabs.

A few things I notice, looking at your example scripts:
You don't need the 'fields' config option in your Store, as it is already defined in your reader
If you're using the latest version of CFQueryReader, you don't have to capitalize your 'mapping' options
You have a space in 'Title Number'. You can use spaces in 'header' configs on ColumnModels, but not in your field config. This is technically an 'id' for the field within a Record object.