Creating a JSON Store using ASP

[joevelardi]

Hi,

I'm wanting to perform a simple test to create a JSON store by having ASP generate the code .. i have generated the ASP code but do not know how to implement this.

In the code below, i have generated the text in Red as ASP - how do i embed this information ?

Is there a simpler way of creating a JSON store ?

var  dsExclusions = new Ext.data.JsonStore({
    fields:  [ 'id' ],
     data:   [ { id: 'Department' },
                {  id: 'Category'     },
                { id: 'Product'       }]
});

[joevelardi]

hehe .. I've found a solution thanks to a quick read; the solution I've found is below:

var dsExclusions = new Ext.data.JsonStore({
    fields : ['id'],
    url : 'http://localhost:9090/include/qryExclusions.asp',
    totalProperty : 'totalCount',
    root : 'records',
    autoLoad : true,
    remoteSort : true
});

The ASP query will create the following output that can be used by the JSON Store;
- The url points to the aps script that generates the code
- totalProperty get the totalCount value which can be used for pagination
- root point to the records field in the generated code

({
    totalCount : '999999',
    records : [  
       { id: 'Department' },
       { id: 'Category'   },
       { id: 'Product'    }
    ]
})