Convert queries for ext

2012-01-12 Thread Tom Small
Hi, I am using a cfc that converts queries to ext grid. When I run the code keep getting error. Would appreciate any help on this issue: 'Unable to parse the JSON returned by the server: You're trying to decode an invalid JSON String:’

Re: Convert queries for ext

2012-01-12 Thread Andrew Scott
Can you show us a snippet of what you trying to do? On Thu, Jan 12, 2012 at 10:01 PM, Tom Small t...@re-base.net wrote: Hi, I am using a cfc that converts queries to ext grid. When I run the code keep getting error. Would appreciate any help on this issue: 'Unable to parse the JSON

Re: Convert queries for ext

2012-01-12 Thread Steve 'Cutter' Blades
To, If you're using that CFQueryReader Ext package, then you want to use ColdFusion's json serialization of the native query object. You want to read that documentation thoroughly, and probably look at the sample code in the download. The purpose behind the custom reader is to allow you to

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew this is my store and ConvertQueriesForExt.cfc: Ext.define('MyApp.store.UserStore', { extend: 'Ext.data.Store', constructor: function(cfg) { var me = this; cfg = cfg || {}; me.callParent([Ext.apply({ autoLoad: true, storeId:

Re: Convert queries for ext

2012-01-12 Thread Andrew Scott
Your problem lies in that you have not converted the Array to a JSon array, therefore your Json is invalid. Might I suggest using FireFox with with Firebug and / or Chrome console to show us what your Json is being returned. I am convinced by looking at the code that a Json Array is not being

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew thanks for your reply and it is now return json format although my problem now is the data not shown in the grid. I would appreciate any help... {ROWS:[{EMAIL:s@gosh.org.uk,USER_PK:1,ISACTIVE:1,USERROLEID:1}],DATASET:1} Thanks Tom

Re: Convert queries for ext

2012-01-12 Thread Matt Quackenbush
Unlike CFML, JavaScript is cAsE sEnSiTiVe, so you'll have to make sure that the case of your keys match on both sides (e.g. CFML and JavaScript). HTH On Thu, Jan 12, 2012 at 8:14 AM, Tom Small t...@re-base.net wrote: Hi Andrew thanks for your reply and it is now return json format although

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Matt, can you please simplify your reply as I am new to extjs and coldfusion. Thanks Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion

Re: Convert queries for ext

2012-01-12 Thread Andrew Scott
What Matt is saying is that ColdFusion will make everything uppercase, so when you create the Grid and the key for binding will also need to be uppercase. If you post the code for a snippet of your Grid, we can show you what we mean. On Fri, Jan 13, 2012 at 1:34 AM, Tom Small t...@re-base.net

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrews, here is the code for my grid. Thanks Tom --- Ext.define('MyApp.view.ui.UsersDetail', { extend: 'Ext.panel.Panel', style: margin: 0px auto 0px auto;, // center the form panel frame: true, height: 450, width: 410, autoScroll: true,

Re: Convert queries for ext

2012-01-12 Thread Andrew Scott
Tom, See these type of lines dataIndex: 'email', This tells the grid to index the data in the store, so in this case you will need to make it dataIndex: 'EMAIL', Hope that helps. On Fri, Jan 13, 2012 at 2:01 AM, Tom Small t...@re-base.net wrote: Hi Andrews, here is the code for my

Re: Convert queries for ext

2012-01-12 Thread Matt Quackenbush
You will also need to make sure that the class/ID names in the markup match the cAsE. HTH On Thu, Jan 12, 2012 at 9:04 AM, Andrew Scott andr...@andyscott.id.auwrote: Tom, See these type of lines dataIndex: 'email', This tells the grid to index the data in the store, so in this case

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew, thanks for your help ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Andrew, Problem solved and thanks for all your help and support. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Matt, Problem solved and thanks for all your help and support. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive:

Re: Convert queries for ext

2012-01-12 Thread Tom Small
Hi Steve, Problem solved and thanks for all your help and support. Tom ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: