I guess I am confused (what's new, right). The link to the actual grid is:

http://dev.thinksys.com/atc/portal/modules/inventory/viewInventory.cfm

That does not load any data in the. The only update I have made to that is I 
made the column names upper case.

The query string from Firebug when that page loads is:
http://dev.thinksys.com/atc/portal/modules/inventory/data.cfc?method=getproducts&returnFormat=json&argumentCollection=%7B%22page%22%3A1%2C%22pageSize%22%3A10%2C%22gridsortcolumn%22%3A%22%22%2C%22gridsortdirection%22%3A%22%22%7D&_cf_nodebug=true&_cf_nocache=true&_cf_clientid=9DD5A34E600C2D12C2BC77ACEDE990C8&_cf_rc=0
 

That displays the JSON data string in the browser when it is clicked it. 

It seems to me like the grid is just not reading the data string for some 
reason. Maybe my code is wrong but I cannot seem to find where.

Again here is the code:

viewInventory.cfm -

<cfform name="productsForm" method="get">
    
<cfgrid name="productsGrid" format="html" pagesize="7" 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>



data.cfc -

<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>


Thanks Again.

>Did you update the copy you pointed me to? Cuz that copy still has the
><link> in the response.
>
>
>> 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf

Archive: 
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:285634
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: 
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4

Reply via email to